Multi Level Subtotals

[ahennema]

I found a formula (see below) that lets me subtotal on changes in 2 columns. However I need to subtotal on changes in 3 columns. IS there a modification to the below formula that would allow me to add one more column? I would check for changes in columns A, B and C and subtotal the value in Column D.

I can get the result using a Pivot Table however I really just want the subtotal to be a running value in column E

I don't understand the formula enough to modify it for one more column...
Spreadsheet Formulas
Cell Formula
D2 =IF(B2=B3,"",SUMPRODUCT(--($A$2:$A$23=A2),--($B$2:$B$23=B2),$C$2:$C$23))

 

[mikerickson]

SUMPRODUCT(--($A$2:$A$23=A2),--($B$2:$B$23=B2),$C$2:$C$23)

Try duplicating the syntax that tests for column A and changing it for column C.

References to what was the summing column (C) should be changed to the new summing column, D.

 

[ahennema]

That worked, below is the actual formula if anybody is interested:


IF(AND(B2=B3, C2=C3), "",SUMPRODUCT(--($A$2:$A$547=C2),--($B$2:$B$547=D2),--($C$2:$C$547=E2),$D$2:$D$547))


Thank you

arich