counting non-blanks

[DJK Moore]

On the topic of counting non-blanks in a column, while NOT counting cells that look blank but actually have a formula in them:

Thought I'd provide more breadcrumbs for future solvers of this problem:

COUNTIF(Range, ">?")

worked great for me. Brilliant idea. I had tried >0 to no avail, so it never occurred to me to try > something else.

I was even able to use the entire column reference as a range (E:E), except then it counted the column heading as well (obviously not blank), so my working formula became

COUNTIF(Range, ">?")-1




EggHeadCafe - .NET Developer Portal of Choice
http://www.eggheadcafe.com/default.aspx?ref=ng

 

[Shane Devenshire]

Hi

That did not work for me, it just returned 0 when the column contained 6
numbers and one formula which returned "". This was true in 2003 and 2007.

 

[Shane Devenshire]

Hi,

The following formula works for me

=SUMPRODUCT(--(LEN(A1:A9)>0))

However, you need to consider: if the cell that looks blank contains a
spacebar or is a formula that evalutes to a space it is counted eventhough it
is not visable.
=IF(A1=3," ",25)