Results 1 to 8 of 8

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

Threaded View

  1. #1
    Registered User
    Join Date
    08-09-2013
    Location
    london
    MS-Off Ver
    Excel 2003
    Posts
    7

    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.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Rolling sum of 12 months against each month based on two criteria
    By agupta5231 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-20-2013, 12:01 AM
  2. Calculate Rolling Sum for Last 12 Months - Variable Entry Intervals
    By jancer in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 09-10-2012, 03:51 PM
  3. Replies: 2
    Last Post: 06-21-2012, 08:17 PM
  4. Replies: 6
    Last Post: 08-30-2011, 08:47 AM
  5. Rolling 12 months
    By Chris Watson in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-05-2008, 01:58 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