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]

Brand	Color	qty
a	red	5		a
a	red	7		red
a	white	8
a	green	9
b	red	4
b	red	2
b	red	9

<tbody>
</tbody>

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