Sum different departmnt
Can anyon help me out?
I have 3 columns A B C. In column A are the departments, B-Names and
C -Contributions.
A C
Account $10
Account $20
Warehouse $10
Account $15
Warehouse $20
HR $15
Warehouse $10
HR $20
HR $30
I would like to type a formula to sum all contributions for each Departs?
Any other way besides the Sorting and then SubtotaL?
Thanks and hope to hear any advice
|