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? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
You could use a tool called pivot tables in Excel. Simply click anywhere in
the list, assuming there are no blabnk rows Choose Data Pivot Table Choose Next Choose Next Choose Layout button if in older version of Excel Drag ID to row area Drag hours to data Choose OK Decide on Location and choose finish or furmual driven, use the Sumif Function . See the Excel formula help for this Eddie "PCStechnical" wrote: 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? |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
One problem I have with the pivot table is that it is not
automatic/won't automatically update. I'm using this program for employees who, needless to say, need as much dummy proofing as possible. Asking them to refresh something may be above them. Will the sumif function work if I don't know what they are inputing for their id's? There can be an endless possibility of id's. I just want something that can put all the same ones together and add it up. Thanks for the help Eddie Holder wrote: You could use a tool called pivot tables in Excel. Simply click anywhere in the list, assuming there are no blabnk rows Choose Data Pivot Table Choose Next Choose Next Choose Layout button if in older version of Excel Drag ID to row area Drag hours to data Choose OK Decide on Location and choose finish or furmual driven, use the Sumif Function . See the Excel formula help for this Eddie "PCStechnical" wrote: 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? |
Reply |
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 |