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

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

Try this............

=COUNTA(A1:A22)-COUNTBLANK(A1:A22)-COUNT(A1:A22)

Vaya con Dios,
Chuck, CABGx3



"Bruce" wrote:

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

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