LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Faio
 
Posts: n/a
Default 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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 10:05 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"