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