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