countif function

  • Thread starter Thread starter susan
  • Start date Start date
S

susan

Need to count alpha letters in a range.
"PP" and "VD". having problems entering criteria, missing
something.
Using =countif(h3:t3,"PP")this works but need to add
additional letter codes to count. How do I write with
multiple criteria?
Thanks everyone for your help. You all are the best!
Lifesavers!
Susan
 
=SUM(COUNTIF(H3:T3,{"PP","VD"}))
Array entered into a two-cell row, the following will enter the number
of PP's in the first cell, the number of VD's in the second:

COUNTIF(H3:T3,{"PP","VD"})

Remember that COUNTIF is not case sensitive.

Alan Beban
 
Back
Top