How do I count shirt sizes and give a total of each?

Sorry for the question. Normally I find answers to my excel questions by going through the help tab or by searching on Google. However, I don't even know what question to ask on this one!?!

Basically I have created a spreadsheet with several columns, but I have one column that lists the shirt size (YS, YM, YL, AS, AM, AL, XL, 2X, 3X) of each person. Is there a formula that I can create that will tabulate the number of sizes (i.e. AS=2, AM=7, etc.)?

In previous years I made a column for each size, and simply placed a "1" in the correct column, and had excel just add the 1's from each column. However, that takes more time and space. I was hoping to streamline it this time around.

Thanks for taking the time to read this post. Any help would be appreciated! Thanks, doug

A Pivot Table would be ideal I think...setting the Shirt Size Column to be both Column Field & Data Field ... the Data Field should default to Count.

Post a sample of your data if you wish to see an example.


Alternatively see COUNTIF function in XL Help... eg

=COUNTIF($D:$D,$F1)
where F1 holds size of interest (YS) and D is column containing shirt sizes... copying the formula down for each shirt size as listed in F1 onwards (ie F2 holds YM, F3 YL and so on and so forth)

Countif() does that...

=Countif(A:A,"AS") counts the number of "AS" in column A..

If you list the sizes somewhere, then you can use something like

=Countif(A:A,X1) and copy it down, where X1, X2, X3, etc display the size to count..

... alternatively you can use a Pivot Table to do all the work....

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save