Look for match and sum values
 

Hi
I have a workbook which has several worksheets. One has personal
details and one has training details. As one record may have several
training information recorded I have created a data validation
dropdown on the training worksheet so no need to re-enter personal
details. I was wanting to have a running total of the number of hours
(which is recorded on the training sheet) for each person. These lists
are built on as we take more participants and offer more training.

Example

Personal Worksheet
A B
1 Bob
2 Gail
3 Fred
4 Gae
5 Gary

Training Worksheet
A B
1 Bob 4
2 Gail 6
3 Gail 1
4 Gae 5
5 Bob 7
6 Bob 8
7 Fred 9
8 Fred 5

If I was wanting to know a running total for each individual as I
enter further information is there a formula that will look up column
A in Personal and if there is a match to Col A in Training add the
values in column B?

Thanks
Debbie

Look for match and sum values
 

In Personal Worksheet B1 enter this formula:

=SUMIF('Training'!A:A,A1,'Training'!B:B)

Copy down as needed.


--
Biff
Microsoft Excel MVP


"DebbieV" wrote in message
...
Hi
I have a workbook which has several worksheets. One has personal
details and one has training details. As one record may have several
training information recorded I have created a data validation
dropdown on the training worksheet so no need to re-enter personal
details. I was wanting to have a running total of the number of hours
(which is recorded on the training sheet) for each person. These lists
are built on as we take more participants and offer more training.

Example

Personal Worksheet
A B
1 Bob
2 Gail
3 Fred
4 Gae
5 Gary

Training Worksheet
A B
1 Bob 4
2 Gail 6
3 Gail 1
4 Gae 5
5 Bob 7
6 Bob 8
7 Fred 9
8 Fred 5

If I was wanting to know a running total for each individual as I
enter further information is there a formula that will look up column
A in Personal and if there is a match to Col A in Training add the
values in column B?

Thanks
Debbie