Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can we get unique values in match function for same match key. | Excel Worksheet Functions | |||
Match Values in Rows with Partial Values in Columns | Excel Worksheet Functions | |||
Match values | Excel Worksheet Functions | |||
How do I match values in one spreadsheet to values in another? | Excel Worksheet Functions | |||
How to match values in one column to values in another? | Excel Worksheet Functions |