COUNT IF < ""
Hi
=COUNTIF($B$10:$B$21,"<")
--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )
"Bruce" wrote in message
...
My Range contains text values. The blanks are not really blank but rather
"".
I would like to count if < to "" as an array formula but I get zero. See
below (n.b have done ctrl+shift+enter)
=COUNT(IF($B$10:$B$21<"""",$B$10:$B$21))
Bruce
|