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

Suza, here is one way,

=SUMPRODUCT(--EXACT(A1:A10,"H"))

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"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

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

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