Count Visible
 

I have a spreadsheet with autofilters. I would like the
count of visible data to change with the filters. Is there
a way to do this like subtotal(9,data)?

Thanks for the assist.

Count Visible
 

Hi
use
=SUBTOTAL(3,data_range)

--
Regards
Frank Kabel
Frankfurt, Germany


Sean wrote:
I have a spreadsheet with autofilters. I would like the
count of visible data to change with the filters. Is there
a way to do this like subtotal(9,data)?

Thanks for the assist.

Count Visible
 

=SUBTOTAL(2,datalist); where datalist is the range name.





"Sean" wrote in message
...
I have a spreadsheet with autofilters. I would like the
count of visible data to change with the filters. Is there
a way to do this like subtotal(9,data)?

Thanks for the assist.