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

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

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

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

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

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

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

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