SUMPRODUCT and (perhaps) SUBTOTAL with AUTOFILTER

[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.....

Please help if you know how to resolve

 

[Peo Sjoblom]

Example here

http://makeashorterlink.com/?B22062C3D

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey

 

[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

 

[Domenic]

Try...

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

Hope this helps!

 

[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....