Auto-filter with Sum product?

J

John

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

Chip Pearson

Try

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

Cordially,
Chip Pearson
Microsoft MVP
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)
 
Top