Thread: Count Visible
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default 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.