ExcelBanter - Auto-filter with Sum product?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Auto-filter with Sum product? (https://www.excelbanter.com/excel-worksheet-functions/212458-auto-filter-sum-product.html)

John

Auto-filter with Sum product?

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

T. Valko

Auto-filter with Sum product?

See your other post

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

Chip Pearson

Auto-filter with Sum product?

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)

On Wed, 3 Dec 2008 18:08:06 -0800, John
wrote:

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

All times are GMT +1. The time now is 11:26 AM.