Sum Quantities Based on 3 Columns

[tineyerin]

I am trying to sum an inventory report which has the same product in different locations. The product is listed by product name and color.

Column A = Brand Name
Column B = Color
Column C = Quantity

Ex.
Brand A Red 5
Brand A Red 7
Brand A White 8
Brand A Green 9
Brand B Red 4
Brand B Red 2
Brand B Red 9

Is there a way to sum if Column A and B are the same in rows 1 and 2, so on and so forth?

Thanks!

 

[t0azt]

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Brand
[/TD]
[TD]Color
[/TD]
[TD]qty
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]a
[/TD]
[TD]red
[/TD]
[TD]5
[/TD]
[TD][/TD]
[TD]a[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]a
[/TD]
[TD]red
[/TD]
[TD]7
[/TD]
[TD][/TD]
[TD]red
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]a
[/TD]
[TD]white
[/TD]
[TD]8
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]a
[/TD]
[TD]green
[/TD]
[TD]9
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]b
[/TD]
[TD]red
[/TD]
[TD]4
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]b
[/TD]
[TD]red
[/TD]
[TD]2
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]b
[/TD]
[TD]red
[/TD]
[TD]9
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Given this:

=SUMIFS(C2:C8,A2:A8,E2,B2:B8,E3)

 

[tineyerin]

Since this is an inventory report with numerous brands and colors, this is a bit impractical.

Since I'm sorting alphabetically by column A and then column B, is there a way to sum when the values in column A change and then when the value in column B changes?

 

[t0azt]

I think a pivot table is the way to go here

 

[Jonmo1]

I think a pivot table is the way to go here

+1