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

1. ## 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

2. ## Re: How do I count shirt sizes and give a total of each?

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)

3. ## Re: How do I count shirt sizes and give a total of each?

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....

4. ## Re: How do I count shirt sizes and give a total of each?

You can use Countif. =countif(a2:A10,"AS") etc...

5. ## Re: How do I count shirt sizes and give a total of each?

Wow, you guys (and gals?) are incredible ... thank you so much! I thought it would take all day to get this figured out. I couldn't believe I had 3 replies within a minute. I guess this was an easy question for you guys. I sure wish I could offer something back, but being that I am ignorant to the inner-workings of excel, all I can say is a big thanks! dc

6. ## Re: How do I count shirt sizes and give a total of each?

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

7. ## Re: How do I count shirt sizes and give a total of each?

Done. Thanks again! dc

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1