SUMPRODUCT and (perhaps) SUBTOTAL with AUTOFILTER

D

Donovan

:( Probably easy to ya'll but I am new to this.

I am trying to SUMPRODUCT two columns that automatically adjust th
answer to the autofilter that is selected..Any advice on how to achiev
this.

I assume it is some sort of SUMPRODUCT and SUBTOTAL combo formula bu
have been unable to figure it out.....:cool:

Please help if you know how to resolve
 
D

Donovan

Dear PEO,

Followed to sample and tried it but came up with value error:

=SUMPRODUCT($F3:$F500,SUBTOTAL(9,I3:I500))

Is this correct or am I missing the boat?

R,
Donova
 
D

Domenic

Try...

=SUMPRODUCT(F3:F500,SUBTOTAL(9,OFFSET(I3:I500,ROW(I3:I500)-ROW(I3),0,1)))

Hope this helps!
 
D

Donovan

Jedi Master Yoda, you really know your stuff.

It works really well.

I am amazed not more folks have published this type of question.
:)

Thanks for the help....
 
Top