Find certain values & add the sum of adjacent

Closed
girlieg86 - Aug 18, 2010 at 07:14 AM
rizvisa1 Posts 4479 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 reply

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
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
-1