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

Sumproduct with autofilter
 

Try it like this:

=SUBTOTAL(9,M3:M468)/SUBTOTAL(9,F3:F468)/1440

--
Biff
Microsoft Excel MVP


"John" wrote in message
...
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????