Find certain values & add the sum of adjacent

Closed
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
769
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