counting non-blanks

D

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
 
S

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

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)
 

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

Formulas and counting 8
Counting non blanks different from "" 4
Blanks and Non blanks 5
Counting blanks, either 1, 2 or 3 5
CountIF 3
Counting Results of Formulas 1
MATCH() and ISERROR() to extract set differences 1
Retriving column header for non empty cells in a row 2

Top