COUNT visible cells?

G

Gregg Stone

I have a filter turned on and need to COUNT only the visible cells in a
column.

Any suggestions?

Thanks in advance for your help.
 
P

Peo Sjoblom

=SUBTOTAL(3,Your_Range)

would be the equivalent of Counta, change the 3 to 2 and it
will be the equivalent of Count (for numeric values)
 
A

Andy B

Gregg

Quick and dirty solution: Click on Edit/Go To/Special/Visible and then copy
and paste in a new sheet.

Andy.
 

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

Top