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

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