Thread
:
COUNT IF < ""
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Ardus Petus
Posts: n/a
COUNT IF < ""
Use following (not Array) formula:
=COUNTIF(B10:B21,"")
HTH
--
AP
"Bruce" a écrit dans le message de news:
...
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
Reply With Quote