A way to count cells in a range containing text or formulas
 

I need to be able to count the number of cells in a range that contain
formulas and text; a way of counting anything within a cell including
a null ("") return value. The range might be something like A1:Z100.
Some of the cells within the range will be merged. Can you suggest a
macro or formula (even better) for this. Thanks for your help in
advance.

A way to count cells in a range containing text or formulas
 

On Mon, 18 Jul 2011 15:08:33 -0700 (PDT), Michael Lanier wrote:

I need to be able to count the number of cells in a range that contain
formulas and text; a way of counting anything within a cell including
a null ("") return value. The range might be something like A1:Z100.
Some of the cells within the range will be merged. Can you suggest a
macro or formula (even better) for this. Thanks for your help in
advance.

=SUMPRODUCT(--NOT(ISBLANK(A1:Z100)))

A way to count cells in a range containing text or formulas
 

Thanks Ron. Your help is much appreciated.

A way to count cells in a range containing text or formulas
 

On Thu, 21 Jul 2011 10:59:03 -0700 (PDT), Michael Lanier wrote:

Thanks Ron. Your help is much appreciated.

Glad to help. Thanks for the feedback.