Our church is selling logo'd clothing to the members.
I have all the orders in a spreadsheet but I can't figure out how to have it calculate pricing. Here is an example...
Code:
PR16BLK Full Zip Hoodie
Adult:
$40 (S-XL)
$45 (2X-3X)
$45 (4X-5X)
Youth:
$30 (XS-XL)
This particular item is in column C where I have the product code (PR16BLK) at the top (row 1)
I have the member names on the rows going down (3 to 27 for example)
I would like to be able to total the prices of the column depending on the size value in each cell. Example, if a person orders an XL we put that in their cell. I can even get it to display the dollar amount at the bottom using;
What I can't figure out is how to add the others sizes to the equation then total them all up at the bottom?
Am I barking up the right tree? Is this something excel can do?
TIA!