Results 1 to 5 of 5

Cumulative sum by date

Threaded View

Cunner Cumulative sum by date 12-22-2015, 12:52 PM
sktneer Re: Cumulative sum by date 12-22-2015, 01:33 PM
Pete_UK Re: Cumulative sum by date 12-22-2015, 01:36 PM
Cunner Re: Cumulative sum by date 12-23-2015, 08:20 AM
Pete_UK Re: Cumulative sum by date 12-23-2015, 02:08 PM
  1. #1
    Forum Contributor
    Join Date
    06-24-2009
    Location
    Germany, MG
    MS-Off Ver
    Excel 2010
    Posts
    131

    Cumulative sum by date

    Hi everyone,

    I have a probably simple problem, but currently do not find an easy solution.
    For reference, please see the attached file.
    I have a database with project payments (WS Payments) by project and month. In the WS Extract I would like to automatically get the sum for the project indicated in column B up to the month indicated in row 2. I have manually added a formula, but the point is to have a formula that checks in WS Payments for the row of the respective project and then builds a sum from the first months (column C) until the month in which the respective cell is located.

    The original data is way more complex and unstructured.

    Any advice is appreciated.
    Attached Files Attached Files
    Last edited by Cunner; 12-23-2015 at 08:20 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 8
    Last Post: 09-05-2015, 05:40 PM
  2. [SOLVED] Cumulative graph within a number of date ranges?
    By JS17 in forum Excel Charting & Pivots
    Replies: 9
    Last Post: 07-20-2015, 11:15 AM
  3. Needing some help with cumulative sums over different date blocks
    By Murphyslaw in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-16-2015, 03:57 AM
  4. Formula required for cumulative costs to date in non-contiguous cells
    By IG2014 in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 10-21-2014, 04:26 AM
  5. [SOLVED] VBA to Pivot by Month and Cumulative Year to Date, then include variance field
    By mike_vr in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-30-2013, 06:00 AM
  6. [SOLVED] cumulative comparison with last year of month to date
    By johnbtor in forum Excel - New Users/Basics
    Replies: 6
    Last Post: 09-04-2012, 10:38 AM
  7. clarification: cumulative to-date total formula needed
    By dreamkeeper in forum Excel General
    Replies: 2
    Last Post: 08-10-2006, 09:55 AM

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