Order form Equation

[gjones]

Hi First post here so please forgive any errors.

I am using Excel 2016 and am creating an order form. I want an Equation that will add up figures in a column if the adjacent two columns meet set criteria. [TABLE="width: 500"]
<tbody>[TR]
[TD]1
[/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]Item
[/TD]
[TD]Size
[/TD]
[TD]Quantity
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]rugby shirt
[/TD]
[TD]S
[/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]rugby shirt
[/TD]
[TD]XS
[/TD]
[TD]2
[/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD]rugby shirt
[/TD]
[TD]S
[/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD]6
[/TD]
[TD]rugby short
[/TD]
[TD]L
[/TD]
[TD]3
[/TD]
[/TR]
[TR]
[TD]7
[/TD]
[TD]rugby shirt
[/TD]
[TD]S
[/TD]
[TD]3
[/TD]
[/TR]
</tbody>[/TABLE]

In the above example I want a formulae that will add up individual cells in column C when firstly column A says Rugby shirt and column B says S so the answer would be 5. In the formulae it has to encompass all row A,B and C minus the top row as as more items are purchased and added to the list the sum result will auto update.

Many Thanks
[TABLE="width: 534"]
<colgroup><col span="3"></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[/TR]
</tbody>[/TABLE]

 

[AlanY]

try thus

=SUMIFS(C:C,A:A,"rugby shirt",B:B,"S")

 

[gjones]

thanks this works perfectly for my needs

 

[AlanY]

you're welcome