Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum different departmnt
You could create a *unique* list of departments, say in K1 to K3,
And then in L1 enter this formula: =SUMIF($A$1:$A$10,K1,$C$1:$C$10) Copy down to L3. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Faio" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum different departmnt
Appreciate the feed-back.
-- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Faio" wrote in message ... Thank very much. It works and this is what I am expecting. "Ragdyer" wrote in message ... You could create a *unique* list of departments, say in K1 to K3, And then in L1 enter this formula: =SUMIF($A$1:$A$10,K1,$C$1:$C$10) Copy down to L3. -- HTH, RD -------------------------------------------------------------------------- - Please keep all correspondence within the NewsGroup, so all may benefit ! -------------------------------------------------------------------------- - "Faio" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum different departmnt
Thank very much.
It works and this is what I am expecting. "Ragdyer" wrote in message ... You could create a *unique* list of departments, say in K1 to K3, And then in L1 enter this formula: =SUMIF($A$1:$A$10,K1,$C$1:$C$10) Copy down to L3. -- HTH, RD -------------------------------------------------------------------------- - Please keep all correspondence within the NewsGroup, so all may benefit ! -------------------------------------------------------------------------- - "Faio" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|