Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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..... 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|