I am making a spreadsheet of T-shirt orders. I am attempting to make each size equal a dollar amount. I want to be able to put the sizes in one cell and the dollar amount add up in the next cell over. For example if a person ordered 3 shirts (YS, AS,AL) I want to be able to put the sizes ordered in one cell. Then each shirt is $25.00 so I want the amount to calculate in the next cell over. Is there a way for me to make each abbreviation equal a dollar amount and it automatically create the sum in the next cell over. Please help me as I am a beginner in Excel.
Bookmarks