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

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.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"DJK Moore" wrote:

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

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)

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"DJK Moore" wrote:

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