cknoderer
asked on
Excel formula for totals
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.
SHIRT-TOTALS.xlsx
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.
SHIRT-TOTALS.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks! That's what I was looking for.
Thanks
Ashok
Ashok
=COUNTIF(B2:B28,"m")
=COUNTIF(B2:B28,"l")
=COUNTIF(B2:B28,"xl")
HTH
Ashok