Results 1 to 2 of 2

Thread: Excel Cumulative Problem

  1. #1

    Talking Excel Cumulative Problem



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Good day, I have the attached file with columns for ID, Date, Hours (Forecast), and Hours (Forecast) Cumulative. I am looking to create a formula in the Hours (Forecast) Cumulative column, by which I can add the Hours (Forecast) values by ID and Date Asc. I have managed to get it to add cumulatively, but it does not do so for each unique ID, only the first one. It also does not add according to Date ascending, but if I make sure dates are sorted Asc I should be ok.

    Any help, please!!!!Excel Cumulative Problem.xlsx

  2. #2
    Magician Hercules1946's Avatar
    Join Date
    Mar 2013
    Location
    York, England
    Posts
    767
    Articles
    0
    Excel Version
    2010
    Try this in D2, copied down:

    =IF(A2<> A1, C2,D1+C2)

Posting Permissions

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