COUNTIF with text criteria

  • Thread starter Thread starter Alexey
  • Start date Start date
A

Alexey

Help please.
I have troubles with COUNTIF. I need to count rows with two criteria in
different columns both are parts of text. For example: text1- “counting text
cellsâ€- criteria- “*text*â€; text2- “C00000005â€-criteria “*5*â€. My COUNTIF
doesn’t work.
 
Use SUMPRODUCT():

Say we have data like:

small cat
medium dog
large mouse
small bird
medium ant
large cat
small dog
medium mouse
large bird
small ant
medium cat
large dog
small mouse
medium bird
large ant
small cat
medium dog
large mouse
small bird
medium ant
large cat

To count the number of rows containing:

small cat

we can use:

=SUMPRODUCT(--(A1:A21="small")*(B1:B21="cat"))

Note that this can be expanded to include as many columns as you want.
 
Thank you,
But what can we do if we have: very small, extremally small and small cats?
and how to cout all small cats?
 
Back
Top