Previous Topic Next Topic

Find certain values & add the sum of adjacent

Closed
girlieg86 - Aug 18, 2010 at 07:14 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Aug 18, 2010 at 07:39 AM
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

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Aug 18, 2010 at 07:39 AM
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
Name Values
brendanconlin -
TrowaD -

1 response
Fill adjacent cell with number from text answer
MitchP -
vcoolio -

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

31 responses