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.
<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>
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>