COUNTIF-how do I count the quantity of 'H', as opposed to 'h'?

S

Suza

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
 
P

Paul B

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
 
B

Bob Phillips

Suza,

Try this

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
B

Bob Phillips

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)
 
Top