Results 1 to 7 of 7

Cumulative SumIF or Index match across multiple columns

Threaded View

  1. #1
    Registered User
    Join Date
    03-29-2020
    Location
    New Zealand
    MS-Off Ver
    Excel 2016
    Posts
    3

    Cumulative SumIF or Index match across multiple columns

    Hi all, first time poster, long time googler here.

    My issue is I am looking for a cumulative sumif or index match type solution to solve my problem (example attached). I have data over 2 sheets, first sheet is where I want the cumulative totals to be listed by month (in columns) and the second sheet is where the data is stored and it can be in any order in the rows on the sheet and will be added to over time, that's why I don't want to use a fixed =SUM formula as the order of the rows could change.

    If I need to add more info to help solve this pls let me know
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Multiple references in one formula. Tried SUMIF, VLOOKUP, INDEX, and MATCH.
    By lazers26 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-24-2019, 10:23 AM
  2. [SOLVED] sumif, index, match + SUM MULTIPLE columns
    By dluhut in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-08-2016, 05:16 PM
  3. VBA code for combined sumif index/match for multiple criteria
    By megaheinz in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 02-16-2016, 11:44 AM
  4. Sumif Index match with multiple column same criteria
    By lilym9053 in forum Excel General
    Replies: 3
    Last Post: 01-08-2016, 12:38 PM
  5. [SOLVED] index match and sumproduct or sumif on multiple criteria
    By tabkaz in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 07-02-2014, 06:20 AM
  6. [SOLVED] need help on Sumif with index and match multiple criteria
    By muheebrahman in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 05-11-2013, 12:53 AM
  7. Replies: 2
    Last Post: 01-27-2012, 01:32 PM

Tags for this Thread

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