Running Subtotal

[HangMan]

I want to calculate a running subtotal on a row by row basis, which is easy enough using:

=SUBTOTAL(9,$AT$3:AT4372)

but I want to base this subtotal on certain criteria from other columns, so I want to effectively say something like:

=SUMIFS($AT$3:$AT$4372,$AT$3:$AT$4372,SUBTOTAL(9,$AT$3:AT4372),$G$3:$G$4372,$G206,$I$3:$I$4372,$I3)

so the subtotal will only update based on the criteria in Colmuns G and I, how could I go about doing this as my approach is clearly wrong?

Many thanks

[oeldere]

you get better help, if you add your excel file, without confidentional information.

Please also add the desired (expected) result.

[oeldere]

Maybe you can filter on column G and I.

And in your subtotalformula you need the value 109 instead of 9.

Without seeing your file, where i can test it,it's a guess.

[HangMan]

Sample attached...

What is the difference between 9 and 109, they appear to give the same results?

[icestationzbra]

in the worksheet that you uploaded, if you could put the value "Company 1" (w/o quotes) in cell G1 and "Red" (w/o quotes) in cell H1, and then reference those static cells, then you could put this formula in cell D3 and drag-fill down:

Please Login or Register  to view this content.

if you were to reference values from within the column(s) that you are attempting to operate on, the results will be a hodgepodge. you could try the following and see how it looks - again in D3 and then drag-filled down:

Please Login or Register  to view this content.

[newdoverman]

For the most part I calculated your expected results but there were 2 that I couldn't see where you may have obtained the expected values. I highlighted these in yellow.

[Marshy3300]

its not elegant but in D4

=SUMIFS($C4:$C4,$A4:$A4,"Company 1",$B4:$B4,"Red")

and d5

=SUMIFS($C4:$C4,$A4:$A4,"Company 1",$B4:$B4,"Red")+D4
you can drop down after that