New to website... How to calculate the sum of last 3 months rolling over each new month!

Hi I am new and I have been trying to work out my problem for so long I am pulling my hair out.

I am trying to calculate the sum of the last 3 months when new data is added every month without having to change the formula.
Like this;
For the last 3 months
Aug-13 5
Sep-13 4
Oct-13 4
Nov-13
Dec-13
Jan-14
Feb-14
Mar-14

Then when I add data it calculates the sum for the last 3 months - now leaving august out and moving down to november
Aug-13 5
Sep-13 4
Oct-13 4
Nov-13 4
Dec-13
Jan-14
Feb-14
Mar-14

I need it to be laid out how I have laid it out in my excel spreadsheet.

I have tried the offset function and it does not work and other formulas only calculate sum of one month.

I have also tried to manually input formula but it doesn't work either.

I have attached the data and I cant change the layout because this needs to be spread company wide. I need the figure for jobs to appear in K6 and the figure for CVsent to appear in L6 an so on.

Imagine I am adding new figures every month.

I know the formula is something like =sum(3months)-previous month but this has to be running.

I have attached the data. Please help. I hope I am making sense.

This one took a little research, but here you go:

Plop this into K6:

Formula:

Please Login or Register  to view this content.

Thanks Daffodil11. This was perfect and so easy to ammend!

I appreciate the help Craig K - my friend had a look at your formula and she let me know this is the way she would do it to - so thanks!

Hi,


I have thought about your problem for some time now and would believe the below/attached is a good solution.

Instead of working with any date formulas I have simply counted the records to identify the last three values and built a INDEX around it.

For the first value, formula would be
=INDEX($B$3:$H$11,COUNT(B3:B11),1)+INDEX($B$3:$H$11,COUNT(B3:B11)-1,1)+INDEX($B$3:$H$11,COUNT(B3:B11)-2,1)

I am sure there is a better way of doing it but at least it is one possibility. Hope that helps.

Find my solutions also attached.
Problem_Solution.xls

Regards from Germany

Thanks for the help Jonny