Function similar to SUMPRODUCT for Subtotal

[Jerseynjphillypa]

I am using the following function below

Please Login or Register  to view this content.

So it does F2*G2*H2 to F35*G35*H35 and then adds the total

But I don't know how to use the Subtotal function similar to sumproduct since I want to use the filters so I can get the updated total

[icestationzbra]

see if this thread helps, else holler back:

http://www.excelforum.com/excel-form...html?p=2911998

[Jerseynjphillypa]

Thanks for the help

I tried to understand the process in the excel but I still couldn't get it to work.

I'm trying to only use the function SUBTOTAL will let you sum "visible/non-filtered" data only.

[icestationzbra]

can you share a sample workbook? we can help you setup the formula.

[jason.b75]

Try

=SUMPRODUCT(F2:F35,G2:G35,H2:H35,SUBTOTAL(2,OFFSET(F2,ROW(F2:F35)-ROW(F2),)))

[Jerseynjphillypa]

I am trying to get the sumproduct code to work for the last row in Column H. But I would like to use a function that uses the table range and when the filters are active only sums the one that shows

[jason.b75]

Try

=SUMPRODUCT([B],[C],[D],SUBTOTAL(2,OFFSET(Table14[[#Headers],[C]],ROW([C])-1,)))

[shadrack]

ExampleShadrack.xlsx
Maybe, you needed something like the attached file. Please comment if your problem is solved.

[shadrack]

ExampleShadrack.xlsx

Updated Function similar to Sumproduct