View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips
 
Posts: n/a
Default 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