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




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!