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

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