excel help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top