+ Reply to Thread
Results 1 to 4 of 4

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

  1. #1
    Registered User
    Join Date
    06-25-2012
    Location
    U.K
    MS-Off Ver
    Excel 2016
    Posts
    98

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

    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.
    Attached Files Attached Files

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    37,306

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

    Try:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  3. #3
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... based in Ireland... but I could be anywhere in the world
    MS-Off Ver
    Office 365 for PC.
    Posts
    35,647

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

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

    I had the sum range at the end..

    Dohhh!!
    Glenn



  4. #4
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,088

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

    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.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Using =COUNTIF to do a sequential count based on three matched columns.
    By randall78 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-05-2021, 07:16 AM
  2. [SOLVED] Running total, progressiv SUMIF
    By GerryZucca in forum Excel General
    Replies: 2
    Last Post: 01-19-2021, 08:10 AM
  3. [SOLVED] Sum total if a different key word in 4 columns is matched
    By bazfalty in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-19-2018, 01:08 PM
  4. Add Multiple Columns Based on matched criteria
    By Moosey71889 in forum Excel General
    Replies: 1
    Last Post: 04-11-2015, 02:27 PM
  5. [SOLVED] Index match sumif for a running total
    By namluke in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-16-2014, 09:17 AM
  6. [SOLVED] Summing columns based on matched values
    By Ace_XL in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-13-2013, 11:32 AM
  7. Excel 2007 : Sumif - inventory/running total
    By CaliberChris in forum Excel General
    Replies: 2
    Last Post: 09-28-2011, 02:10 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1