?
Solved

Excel formula for totals

Posted on 2013-12-27
4
Medium Priority
?
622 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 2000 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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Microsoft has changed the look and feel of Azure AD and Microsoft account sign-in pages so that you will have a more unified look and feel when moving between the two interfaces.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…

719 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