or =SUMPRODUCT(--(ISNUMBER(FIND("H",I1:I20))))

if you want capital h's <G

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Bob Phillips" wrote in message
...
Suza,

Try this

=SUMPRODUCT(--(ISNUMBER(FIND("h",I1:I20))))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Suza" wrote in message
...
The problem is how to ask the system to count CAPITAL h's as opposed to
LOWER
case h's.
I am using COUNTIF but it's counting H and h as the same