Summing values in database according to multiple criteria

P

Peter

Dear All
I have a spreadsheet;
A B D E
Dept Account Staff Amount
1 AA 1002 Peter 10
2 BB 1002 John 20
3 AA 1002 Peter 30
4 CC 1002 Paul 40

I want to sum the content column E by Dept (A), Account Number (B), and Staff (D). How can I do this by formula? As opposed to pivot tables.
Many thanks
Peter
 
A

Andy Wiggins

Take a look at the SUMPRODUCT function.

--
Regards
Andy Wiggins
www.BygSoftware.com
Home of "Save and BackUp",
"The Excel Auditor" and "Byg Tools for VBA"



Peter said:
Dear All
I have a spreadsheet;
A B D E
Dept Account Staff Amount
1 AA 1002 Peter 10
2 BB 1002 John 20
3 AA 1002 Peter 30
4 CC 1002 Paul 40

I want to sum the content column E by Dept (A), Account Number (B), and
Click to expand...
Staff (D). How can I do this by formula? As opposed to pivot tables.
 
Top