Countif with multiple text values in cell

R

Rothman

I have a column of state abbreviations and am simply trying to count how many
times each state appears in the column.

Unfortunately, there are some cells in the column that contain two or more
states. Countif doesn't like that (i.e if VA is in one cell and "MD VA NY"
is in another, it doesn't count VA twice).

What do I do? This isn't the only data in my sheet, so adding columns would
be...messy.
 
F

FSt1

hi
=countif(A1:A50,"*VA*")

use the wildcard * in the search. adjust range to suit.

Regards
FSt1
 
T

T. Valko

Try this:

=COUNTIF(A1:A10,"*Va*")

Or, use a cell to hold the criteria:

C1 = Va

=COUNTIF(A1:A10,"*"&C1&"*")

If a cell might hold:

MD VA VA

And you need to count that as 2 then you'll need a different formula. Let us
know if that's the case.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

CONDITIONAL SUM FOR MULTIPLE CRITERIA IN SINGLE RANGE 1
Cell Population based on a Table 2
countif with two criteria one a column of dates? 3
countif when 2 values in a cell 9
COUNTIF, Sorting, Two Sheets 0
Countif with multiple criteria 0
Countif 3
Counting Cells with Multiple Range Criteria (Excel 2003) 7

Top