Using SUMIF to keep a running total based on there being matched data in three columns.

[randall78]

Hi,

I am trying to create a running total column in a table to keep an accumulative total if three of the other columns data are a match. ie Line,Batch,Quarter.

I have included a Sample file.

[TMS]

Try:

Please Login or Register  to view this content.

[Glenn Kennedy]

Senior moment... Could I get this @~#@ing thing to work???

I had the sum range at the end..

Dohhh!!

[Bo_Ry]

Please try

=SUMIFS(E$5:[@amount], B$5:[@LINE], [@LINE], D$5:[@BATCH],[@BATCH])

or
=SUMIFS(Table1[[#Headers],[amount]]:[@amount], Table1[[#Headers],[LINE]]:[@LINE], [@LINE], Table1[[#Headers],[BATCH]]:[@BATCH],[@BATCH])

This way the last row still sum correctly when adding more record to the table.