| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup and sum- to lookup a name and return and sum of all instan
Hi there,
I have a table with the hours that employees have worked (as shown below)and I need to sum all hours. There are numerous entries for each employee and so I need a formula that will look for the name in column a and then I need to sum all hours entered in column B next to that name. Please advise :-) Name B C D adelle 22.50 16.00 1.00 Alice 82.25 79.25 0.00 Alice 19.75 18.75 0.00 Alice 19.75 18.75 0.00 Aqsa 35.00 32.25 0.00 Chen 49.75 49.25 1.00 Chen 19.25 17.75 0.00 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
vlookup and sum- to lookup a name and return and sum of all instan
Try
=SUMIF(A:A,"adelle",B:B) If this post helps click Yes --------------- Jacob Skaria "pumpkin" wrote: Hi there, I have a table with the hours that employees have worked (as shown below)and I need to sum all hours. There are numerous entries for each employee and so I need a formula that will look for the name in column a and then I need to sum all hours entered in column B next to that name. Please advise :-) Name B C D adelle 22.50 16.00 1.00 Alice 82.25 79.25 0.00 Alice 19.75 18.75 0.00 Alice 19.75 18.75 0.00 Aqsa 35.00 32.25 0.00 Chen 49.75 49.25 1.00 Chen 19.25 17.75 0.00 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
vlookup and sum- to lookup a name and return and sum of all in
Brilliant thanks Jacob :-)
"Jacob Skaria" wrote: Try =SUMIF(A:A,"adelle",B:B) If this post helps click Yes --------------- Jacob Skaria "pumpkin" wrote: Hi there, I have a table with the hours that employees have worked (as shown below)and I need to sum all hours. There are numerous entries for each employee and so I need a formula that will look for the name in column a and then I need to sum all hours entered in column B next to that name. Please advise :-) Name B C D adelle 22.50 16.00 1.00 Alice 82.25 79.25 0.00 Alice 19.75 18.75 0.00 Alice 19.75 18.75 0.00 Aqsa 35.00 32.25 0.00 Chen 49.75 49.25 1.00 Chen 19.25 17.75 0.00 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
vlookup and sum- to lookup a name and return and sum of all instan
Hi,
You may also create a pivot table. Drag employee name to the row area and hours to the data area. -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "pumpkin" wrote in message ... Hi there, I have a table with the hours that employees have worked (as shown below)and I need to sum all hours. There are numerous entries for each employee and so I need a formula that will look for the name in column a and then I need to sum all hours entered in column B next to that name. Please advise :-) Name B C D adelle 22.50 16.00 1.00 Alice 82.25 79.25 0.00 Alice 19.75 18.75 0.00 Alice 19.75 18.75 0.00 Aqsa 35.00 32.25 0.00 Chen 49.75 49.25 1.00 Chen 19.25 17.75 0.00 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLookUp - Does the VLookUp return the exact information? | Excel Worksheet Functions | |||
| LOOKUP and return the column heading for IF/THEN return for False | Excel Discussion (Misc queries) | |||
| VLOOKUP CONDITION TO RETURN BLANK CELL WHERE LOOKUP VALUE IS NOT IN TABLE ARRAY | Excel Worksheet Functions | |||
| How do I lookup and return different values when the lookup value. | Excel Discussion (Misc queries) | |||
| How can I stop Excel from correcting data in a sp.sheetfor instan. | Excel Discussion (Misc queries) | |||
Linear Mode
