| 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 |
| 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) | |||
Threaded Mode
