View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Lee Coleman Lee Coleman is offline
external usenet poster
 
Posts: 9
Default CountA with filtered column

How do I count the values in the rows showing in a column after applying a
filter to the worksheet? When I do something like =counta(b2:b450) I get 449
but this is not correct after using the filter.
Thanks,
--
Lee Coleman