View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Donovan
 
Posts: n/a
Default 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.....

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