Posted to microsoft.public.excel.worksheet.functions

John

external usenet poster

Posts: 2,069

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
SUMPRODUCT w/ Autofilter	Mike	Excel Discussion (Misc queries)	2	January 4th 08 08:26 PM
Autofilter & Sumproduct	jwwj232	Excel Discussion (Misc queries)	2	October 31st 07 01:30 PM
Using Sumproduct in Autofilter	forest8	Excel Worksheet Functions	1	June 7th 07 09:43 AM
SUMPRODUCT with Autofilter	Gustavo Strabeli	Excel Worksheet Functions	3	April 12th 07 05:32 PM
Using AutoFilter + sumproduct formula	VLB	Excel Discussion (Misc queries)	2	December 8th 06 02:30 AM

All times are GMT +1. The time now is 08:15 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us