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

M

Michael Lanier

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.
 
R

Ron Rosenfeld

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.
Click to expand...

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dealing with the error: unable to filter on excel hc home school 0
Macro to Select text from a point given to a specific word 2
Converting URLs in comments to Markdown-formatted links 2
How to count cells with same fill colour containing same text...JoeMoe 0
How to delete ALL cells containing the same data 1
Quickly count used rows? 5
Where am I going wrong? Cells reference to a range appears to havestopped working! 5
Keeping formulas on an insert 1

Top