Thread: SUMPRODUCT and (perhaps) SUBTOTAL with AUTOFILTER
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Domenic
 
Posts: n/a
Default 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
Reply With QuoteReply With Quote