View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Hospice Volunteer Services Hospice Volunteer Services is offline
external usenet poster
 
Posts: 1
Default How do I use count, sum, or avg formulas on autofiltered results.

When I attempt to use simple formulas on the displayed autofiltered results,
Excel includes cells hidden by the search. How do I get results on the
displayed cells only.