Solved

Excel formula for totals

Posted on 2013-12-27
4
555 Views
Last Modified: 2013-12-28
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
0
Comment
Question by:cknoderer
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 13

Expert Comment

by:Ashok
ID: 39742002
=COUNTIF(B2:B28,"s")
=COUNTIF(B2:B28,"m")
=COUNTIF(B2:B28,"l")
=COUNTIF(B2:B28,"xl")

HTH
Ashok
0
 
LVL 9

Accepted Solution

by:
Christopher Jay Wolff earned 500 total points
ID: 39742046
You should probably use the Countif function built into excel.  A good example is attached.

If I remember correctly from looking at your spreadsheet, the formulas in your totals will read something like...

countif(B1:B28,"s")

and so forth.

Is that what you're looking for?
Capture.PNG
0
 
LVL 1

Author Closing Comment

by:cknoderer
ID: 39742062
Thanks!  That's what I was looking for.
0
 
LVL 13

Expert Comment

by:Ashok
ID: 39742137
Thanks
Ashok
0

Featured Post

Increase your protection from Zero Day threats!

Running two Antivirus' is never a good idea.
Taking advantage of Multiple Security layers on the other hand can often save your hide.
See which top notch security software brands have been proven to happily coexist together.
Reduce your chances of becoming a statistic.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question