countif function

[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

 

[Don Guillett]

=SUMPRODUCT((I1:I11={"pp","vd"})*1)

 

[Alan Beban]

=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