Sum Duplicates in Groups

  • Thread starter Thread starter Zesty
  • Start date Start date
Z

Zesty

I have a file that has quantity and codes. Each code has an amount, but they
are different amounts and the code duplicates many times. I need a formula
that totals each group of codes. The codes cannot be sorted so they are all
together they must be separate to keep lots together.

C = The results I would like to have.


A B C
10 AR5 10
25 AC6
25 AC6 50
15 AR5
25 AR5
25 AR5 65
12 AC6
10 AC6 22
22 XR6


Any help would be appreciated!!
Thank You
 
Hi,

Assume that your data is in range A5:B13. In A4, type numbers, in B4, type
code and in C4, type Sum. In cell C5, enter

=IF(OR(B5=B6,B6=""),"",DSUM($A$4:B5,$A$4,$A$4:B5)-SUM($C3:C$4))

Hope this helps

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
 
Back
Top