Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Here is my delima
In column one, a person can input their ID number. In Column two, they input hours of work. Now there are multiple employees using the same sheet. What I want to do is create a formula that adds all the values in column two that correspond with each id number. In other words, I want to make a formula that groups all the values from the same ID number and adds them up. Eventually I want to make a list that summarizes by employee id their total hours worked. Any sugguestions? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VLookup Multiple Data Rows | Excel Worksheet Functions | |||
Select rows of data in a worksheet on one criteria in multiple co | Excel Worksheet Functions | |||
Sort pages? | Excel Discussion (Misc queries) | |||
Select all data, multiple rows | Excel Discussion (Misc queries) | |||
Lookup values in a list and return multiple rows of data | Excel Worksheet Functions |