+ Reply to Thread
Results 1 to 6 of 6

Needing some help with cumulative sums over different date blocks

  1. #1
    Registered User
    Join Date
    01-14-2013
    Location
    united states
    MS-Off Ver
    Excel 2003
    Posts
    14

    Exclamation Needing some help with cumulative sums over different date blocks

    Hi, so I will try explaining what I need simply if possible. I have four columns, Item, Category, Date and Rate. I need to create two column from this data, a Cumulative Days column and a cumulative rate column, these columns need to be per item, per code and per date, and only adding cumulative for consecutive dates. So if the item, changes the cumulative values would need to start over, if the code changes the cumulative values would need to start over, and if there is a break in the date/ not consecutive days, the cumulative values needs to start over. I have included a file with a sample of the data I have and the data I need to calculate hopefully to make this easier to understand.

    Hopefully someone will be brave enough to take this on! Please let me know if you need more clarification and hopefully I can give it! :D
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    01-14-2013
    Location
    united states
    MS-Off Ver
    Excel 2003
    Posts
    14

    Re: Needing some help with cumulative sums over different date blocks

    Fixed wording!

  3. #3
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: Needing some help with cumulative sums over different date blocks

    G3:
    Please Login or Register  to view this content.
    H3:
    Please Login or Register  to view this content.
    and copy down
    Attached Files Attached Files
    Make Mom proud: Add to my reputation if I helped out!

    Make the Moderators happy: Mark the Thread as Solved if your question was answered!

  4. #4
    Registered User
    Join Date
    01-14-2013
    Location
    united states
    MS-Off Ver
    Excel 2003
    Posts
    14

    Re: Needing some help with cumulative sums over different date blocks

    Wow youre fast! Thanks so much! One question from playing around with this, is there a way to make it so the formula works even when filtering differently...like when I try and filter how to columns sort the formulas no longer correctly adds the days up right.

  5. #5
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: Needing some help with cumulative sums over different date blocks

    Let me think if there's an efficient way to show the same information if the dates are out of order. HRMMMM.

  6. #6
    Forum Guru karedog's Avatar
    Join Date
    10-03-2014
    Location
    Indonesia
    MS-Off Ver
    2003
    Posts
    2,971

    Re: Needing some help with cumulative sums over different date blocks

    Hi,

    This formula will work, even the table is not sorted.
    Put this formula on cell I3 :

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


    Regards
    1. I care dog
    2. I am a loop maniac
    3. Forum rules link : Click here
    3.33. Don't forget to mark the thread as solved, this is important

+ 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] Excel novice needing assistance with cumulative totals
    By jlwhitten in forum Excel General
    Replies: 5
    Last Post: 04-13-2014, 08:41 AM
  2. [SOLVED] Cumulative sums
    By kipronopaul in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-11-2012, 08:21 AM
  3. cumulative sums
    By Icarni in forum Excel General
    Replies: 6
    Last Post: 11-02-2009, 10:41 AM
  4. Help regarding cumulative sums
    By karaflas01 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-30-2008, 09:30 AM
  5. Cumulative Sums in Pivot Tables
    By Laura in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 01-11-2006, 02:00 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