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.