COUNT IF <> ""

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Back
Top