Sum Product on filtered data only

Corleone

Well-known Member
=SUMPRODUCT(--('GRIP STAGES'!$C$5:$C$4000=$B8),'GRIP STAGES'!T$5:T$4000)

How would I alter this so that it returns only the sum total of the source data that is filtered?

thanks
 

Domenic

MrExcel MVP
Try...

=SUMPRODUCT(--('GRIP STAGES'!$C$5:$C$4000=$B8),SUBTOTAL(9,OFFSET('GRIP STAGES'!T$5:T$4000,ROW('GRIP STAGES'!T$5:T$4000)-ROW('GRIP STAGES'!T$5),0,1)))

To exclude manually hidden cells as well, replace the number 9 in red with 109.

Hope this helps!
 
Last edited:

Some videos you may like

This Week's Hot Topics

Top