=SUMPRODUCT(--(ISNUMBER(MATCH(H$7:H$1300,{"Q","S"},0))))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"David_Williams_PG" wrote in
message ...
Am sure their is an easy answer to this !! But am trying to count the
number
of times the letter Q and S appear in the samE column.

The formulae to count Q which works is as below :-

{=SUM(IF(H$7:H$1300 = "Q",1,0))}

What I would like to write for Q and S is :-

{=SUM(IF(H$7:H$1300 = "Q" or "S",1,0))}

But it does not work !!!!!!!!!

Would really appreciate any help on this,
Thanks,
David.