Count Visible

[Sean]

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.

 

[Frank Kabel]

Hi
use
=SUBTOTAL(3,data_range)

 

[Paulw2k]

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