Solved

How can i add the number of cells in excel with given text criteria?

Posted on 2013-05-09
2
256 Views
Last Modified: 2013-05-15
I have a few simple spreadsheets in excel and want to sum a few of the columns in which there is text.  E.G. one column is the geographical location.  "XYZ"  I would like a formula to quickly sum the number of cells that have "XYZ" in it.  

I have tried the SUMIF formula but does not seem to be working.  i get a blank cell.
0
Comment
Question by:YankeeFan03
2 Comments
 
LVL 23

Accepted Solution

by:
Danny Child earned 500 total points
ID: 39153935
to count a range of cells that match TEXT criteria, use =COUNTIF(range,"XYZ")
 - you can of course replace "XYZ" with a cell reference.

SUMIF is better for *numerical* comparisons, ie Sum all cells that are bigger than a certain value.
0
 

Author Closing Comment

by:YankeeFan03
ID: 39169584
perfect.  works like a charm.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Macro Capitalize 4 54
Configure Sharepoint 2013 to allow Excel files to be edited online 9 56
highlight duplicate entry 16 29
Excel Save As Status Box will not go away 6 17
Introduction This Article is a follow-up to my Mappit! Addin Article (http://www.experts-exchange.com/A_2613.html), it was inspired by an email posting I made to EUSPRIG (http://www.eusprig.org/index.htm), I will briefly cover: 1) An overvie…
Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…

911 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now