Posted to microsoft.public.excel.worksheet.functions

scott

external usenet poster

Posts: 577

Help using autofilter & Sumproduct

Hi

I'm using this formula to add up unique fields (peoples names who appear
many times)

=SUMPRODUCT((L3:L2052<"")/COUNTIF(L3:L2052,L3:L2052&""))

Is there a way to adapt this so that when I auto filter it will only add up
the visible unique cells?

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 with autofilter	John	Excel Worksheet Functions	1	December 4th 08 02:33 AM
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

All times are GMT +1. The time now is 11:56 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us