Thread: excel help
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
donovan donovan is offline
external usenet poster
 
Posts: 4
Default 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