SUMPRODUCT and (perhaps) SUBTOTAL with AUTOFILTER
 

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

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

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

Please help if you know how to resolve.


--
Donovan
------------------------------------------------------------------------
Donovan's Profile: http://www.excelforum.com/member.php...o&userid=35234
View this thread: http://www.excelforum.com/showthread...hreadid=550112

SUMPRODUCT and (perhaps) SUBTOTAL with AUTOFILTER
 

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" wrote in
message ...

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

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

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

Please help if you know how to resolve.


--
Donovan
------------------------------------------------------------------------
Donovan's Profile:
http://www.excelforum.com/member.php...o&userid=35234
View this thread: http://www.excelforum.com/showthread...hreadid=550112

SUMPRODUCT and (perhaps) SUBTOTAL with AUTOFILTER
 

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,
Donovan


--
Donovan
------------------------------------------------------------------------
Donovan's Profile: http://www.excelforum.com/member.php...o&userid=35234
View this thread: http://www.excelforum.com/showthread...hreadid=550112

SUMPRODUCT and (perhaps) SUBTOTAL with AUTOFILTER
 

Try...

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

Hope this helps!

In article ,
Donovan wrote:

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,
Donovan

SUMPRODUCT and (perhaps) SUBTOTAL with AUTOFILTER
 

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


--
Donovan
------------------------------------------------------------------------
Donovan's Profile: http://www.excelforum.com/member.php...o&userid=35234
View this thread: http://www.excelforum.com/showthread...hreadid=550112