Do any of the cells contain formula blanks?

Try one of these (accounts for formula blanks):

=SUMPRODUCT(--(LEN(D9:D30)0))

=ROWS(D9:D30)-COUNTBLANK(D9:D30)

--
Biff
Microsoft Excel MVP


"Claudia d'Amato" wrote in message
...
I would like to count the number of non-zero (=non-blank) cells in a range
(say D9:D30).

How can I do this with an Excel formula ?

Claudia