Results 1 to 7 of 7

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

Threaded View

  1. #1
    Registered User
    Join Date
    06-23-2009
    Location
    Sweetwater, Texas
    MS-Off Ver
    Excel 2003
    Posts
    3

    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
    Last edited by dc112675; 06-23-2009 at 12:40 PM.

Thread Information

Users Browsing this Thread

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

Bookmarks

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