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