Totaling Rows That Match Given Criteria

[jtoscani]

Product	SKU	Sales (Units)	Total Units Per SKU
Shampoo	123456	500
Conditioner	123455	1200
Shampoo Fine	123440	1205
Shampoo Curly	123440	600
Conditioner Fine	123440	1701
Conditioner Curly	123440	1923

I am trying to sum up the totals of rows if the SKU columns match.

Row 2 should read 500,
Row 3 should read 1,200
Row 7 should read 5,429.

I tried "Countif" but I would need to use each SKU in quotations and I have hundreds to go through. I have been staring at this for a while now and my brain has become mush. Perhaps there is an easier way to do this? Thank you for your help!

[Ace_XL]

Use SUMIF instead

Or even better..try pivot tables
www.cpearson.com/excel/pivots.htm

[jtoscani]

Thank you for your reply. The Pivot Table is a great idea. However, how would you use the SumIF Function you specified as well? What would the syntax be? Or would it also involve quotations?

[Ace_XL]

For your table use this in Row 2..

=SUMIF(B:B,B2,C:C)

[jtoscani]

Awesome! Thanks again!!!

[Kevin UK]

Hi jtoscani

Just to take it one further!

In Row 2, Column 4:

Please Login or Register  to view this content.

If you want to highlight the row, conditional format:

Please Login or Register  to view this content.

[jtoscani]

Thank you Kevin, this also worked well!