Counting Non Blank Cells in a Filtered Column

[Onebracketshort]

Anybody know of a way to count the non blank cells in a filtered column for several thousand visible cells? Its not a hidden row scenario just a filtered column.

As a workaround I’ve been copying the column into a Word document and doing a word count, which is not ideal.

Any ideas?

 

[MARK858]

displays as text in the cell rather than as a function

Try putting your cursor in front of the equals sign and press backspace a few times.

 

[Onebracketshort]

=CODE(C2) gives a value of "0" for all blank cells

 

[jasonb75]

displays as text in the cell rather than as a function

Sounds like either the cell was formatted as text when you entered the formula, or you pressed Ctrl and ` together.

 

[Onebracketshort]

=SUMPRODUCT(SUBTOTAL(3,OFFSET($F$2,ROW($F$2:$F$99999)-ROW($F$2),))*(LEN($F$2:$F$99999)>0))

works after I got it as text format and got rid of spaces etc

thanks to all of you, you got me over the line with this one. I can't tell you how much time you've saved me