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

**randall78** · 02-17-2021, 12:56 PM

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** · 02-17-2021, 01:06 PM

Try:

Formula:

Please Login or Register  to view this content.

**Glenn Kennedy** · 02-17-2021, 01:13 PM

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

I had the sum range at the end..

Dohhh!!

**Bo_Ry** · 02-17-2021, 01:36 PM

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.

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

LinkBack

Thread Tools

Rate This Thread

Display

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

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

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

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

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Using =COUNTIF to do a sequential count based on three matched columns.

[SOLVED] Running total, progressiv SUMIF

[SOLVED] Sum total if a different key word in 4 columns is matched

Add Multiple Columns Based on matched criteria

[SOLVED] Index match sumif for a running total

[SOLVED] Summing columns based on matched values

Excel 2007 : Sumif - inventory/running total

Bookmarks

Bookmarks

Posting Permissions