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
|