G Gregg Stone Sep 22, 2003 #1 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.
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 Sep 22, 2003 #2 =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)
=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 Sep 22, 2003 #3 Gregg Quick and dirty solution: Click on Edit/Go To/Special/Visible and then copy and paste in a new sheet. Andy.
Gregg Quick and dirty solution: Click on Edit/Go To/Special/Visible and then copy and paste in a new sheet. Andy.
