View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John John is offline
external usenet poster
 
Posts: 2,069
Default Sumproduct with autofilter

I am trying to use sum product I believe for the following formula.....

=(SUM(M3:M468)/SUM(F3:F468))/1440

I am trying to use auto-filter to give me the above answer for just the
fields shown after filtering. Any ideas????