Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel help
I have download a spreadsheet that has names of people, check numbers,
departments, and total of each checks. I need help constructing a table to where it will sum up each person having a total number of checks and dollar amount. This is what I currently have EMPLOYEE NAME # checks department amount REYES,ORLANDO 55-621000 4.46 REYES,ORLANDO 55-621000 13.80 This is what I need EMPLOYEE NAME # checks department amount REYES,ORLANDO 2 55-621000 18.26 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel help
If you sort by employee name go to Data-Subtotals and do a count of checks
and sum of amounts and that should do it for you -- -John Please rate when your question is answered to help us and others know what is helpful. "donovan" wrote: I have download a spreadsheet that has names of people, check numbers, departments, and total of each checks. I need help constructing a table to where it will sum up each person having a total number of checks and dollar amount. This is what I currently have EMPLOYEE NAME # checks department amount REYES,ORLANDO 55-621000 4.46 REYES,ORLANDO 55-621000 13.80 This is what I need EMPLOYEE NAME # checks department amount REYES,ORLANDO 2 55-621000 18.26 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|