Counting non-blank cells in a column, excluding hidden rows

[SisterDell]

How do I do this?

 

[Don Guillett]

will the SUBTOTAL function help?

 

[SisterDell]

Yes, but it adds in extra rows to subtotal every occurrence. But it did do
the trick! Thank you.

 

[Don Guillett]

glad to help