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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sort list of names 1
When using subtotals in Excel, how do you bold the dollar amount? 1
Sandwich existing formulas with "If iserror(formula),0,formula)" 10
Average if questions 2
auto renumbering rows with blank spaces 5
HELP If range equals 2
Formula For Multiple Rows 2
Excel help!? 3

Back
Top