Thread
:
Counting non-blank cells
View Single Post
#
6
Posted to microsoft.public.excel.misc
Sandy Mann
external usenet poster
Posts: 2,345
Counting non-blank cells
Yes, on re-reading the OP's post you are quite right - I got it wrong! :-(
My appologies.
--
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
Replace @mailinator.com with @tiscali.co.uk
"Peo Sjoblom" wrote in message
...
I assumed that's what the OP wanted. I read his question as to count cells
that are not blank,
whether it is from the cell being empty or from it having a formula
returning a blank
Peo
"Sandy Mann" wrote in message
...
Peo Sjoblom" wrote in message
... One way
=SUMPRODUCT(--(LEN(A1:A10)0))
Doesn't that return 0 for cells with "" in them?
I was going to post:
=COUNTBLANK(A1:A10)-COUNTIF(A1:A10,"*")
or
=COUNTIF(A1:A10,"=")
or the array entered:
=SUM(--ISBLANK(A1:A10))
But I was trying to work out if Harlan would come along and point out
where they would fail as well.
--
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
Replace @mailinator.com with @tiscali.co.uk
Reply With Quote
Sandy Mann
View Public Profile
Find all posts by Sandy Mann