I'm trying to help a user get the totals of shirt sizes in an excel file. They routinely come across this and would like to be able to enter in a formula that auto calculates the totals for the different shirt sizes. I've attached a sample of what they are trying to accomplish. There are some details listed below. Thanks for any and all help.
We have 27 different people with varying shirt sizes. Ranging from Small to XL. I need a formula that would auto calculate the shirt sizes then put them into the various corresponding cells for the shirt size totals for each size.