I created a table in Excel that I am using to add up orders of T-Shirts. I created lists for the various t-shirt sizes and used the count if function to give me a total of the respective size ordered by each person. Now my problem is people that ordered more than one of a certain size. For example, I have someone who ordered 2 Adult Smalls, but in the total it only adds 1. Is there any way to be able to multiply this to give me a correct total using this list style. I'm pretty new when it comes to using excel and just learned about making lists and using the countif function. Thank you for your help!
Bookmarks