+ Reply to Thread
Results 1 to 2 of 2

Accumulation of data over time

  1. #1
    Registered User
    Join Date
    04-13-2012
    Location
    Warsaw, Poland
    MS-Off Ver
    Excel 2003
    Posts
    1

    Accumulation of data over time

    Hi,

    My question might be answered in different topic, but I am so new to Excel that I cannot write a good short description of my problem to find an answer with search.

    I have a column of data, Clipboard03.jpg and time.

    The Value column is is the value generated by a project per month starting with the delivery date.

    My problem is that acummulating this data just generates a simple sum for each month, like A1+A2, A2+A3, etc...

    Is there anyway to automatize such calculations, so Excel each month will add the accumulated generated value of each project? I tried working with pivot tables, but could just get a accumulated value like each project just generated 5 value, instead of 5 per month.

    Ex.
    After 6 months, Project 1 would generate 6*5 (6 month*value), Project 2 will generate 5,5*3 (since it started 15 days after project 1) etc...


    The end result would be a chart showing the correct accumulated generated value for each datapoint (dates).



    Thank you for your help.

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Accumulation of data over time

    Its much better to upload an excel file instead of a jpg.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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