Sum according to Auto filter non visible cells

**Domenic** · 08-10-2009, 03:03 AM

Here's another way...

=SUMPRODUCT(--(B5:B25>5),SUBTOTAL(9,OFFSET(A5:A25,ROW(A5:A25)-ROW(A5),0,1)

**ElmerS** · 08-10-2009, 12:36 PM

Originally Posted by Domenic

Here's another way...

=SUMPRODUCT(--(B5:B25>5),SUBTOTAL(9,OFFSET(A5:A25,ROW(A5:A25)-ROW(A5),0,1)

Thanks, Domenic.

**DonkeyOte** · 08-10-2009, 12:45 PM

and as you no doubt know generally speaking Volatile Sumproducts will kill performance -- volatile here given use of OFFSET ... and obviously filtering is a Volatile action in it's own right (in part because of SUBTOTAL Function)

Sum according to Auto filter non visible cells

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Re: Sum according to Auto filter non visible cells

Re: Sum according to Auto filter non visible cells

Re: Sum according to Auto filter non visible cells

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions