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.

1	A	B	C
2	Item	Size	Quantity
3	rugby shirt	S	1
4	rugby shirt	XS	2
5	rugby shirt	S	1
6	rugby short	L	3
7	rugby shirt	S	3

<tbody>
</tbody>

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

<colgroup><col span="3"></colgroup><tbody>
</tbody>

 

[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