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.
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.
Try:Formula:
Please Login or Register to view this content.
Senior moment... Could I get this @~#@ing thing to work???
I had the sum range at the end..
Dohhh!!
Glenn
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks