Previous Topic Next Topic

Find certain values & add the sum of adjacent

Closed
girlieg86 - 18 Aug 2010 à 07:14
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 18 Aug 2010 à 07:39
Hello,





I hope you under stand this, I have codes in column C and corresponding amounts in Column D. I would like to set up other cells that have the totals of all the codes. What formula should I use? Thanks!

What I have:
Colums: C > > D
Division > > Amount
1 > > 100
2 > > 200
3 > > 100
1 > > 300
2 > > 100
3 > > 200


What I would like to see:
Colums: F > > G
Division 1 > > 400
Division 2 > > 300
Division 2 > > 300

1 response

Réponse 1 / 1
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
18 Aug 2010 à 07:39
Values of column F (Division 1, Division 2...) is the issue. If you can either type, or use Data- Advance Filter option to get the unique values of column C, then you can use SUMIF for getting the totals

Similar discussions

help me to add particular cells
mathewmunna -
mathew munna -

2 responses
Clear cell contents based on value of another cell range using VBA
Tbonekiller -
Tbonekiller -

6 responses
Fill adjacent cell with number from text answer
MitchP -
vcoolio -

20 responses
Ig stories from close friends to public
Darren -
zara -

31 responses
Return Seq Values Until Blank value then return different set of seq values
lorieb63 -
TrowaD -

1 response