+ Reply to Thread
Results 1 to 2 of 2

Need a 12 month rolling value

  1. #1
    Forum Contributor
    Join Date
    02-02-2012
    Location
    Michigan
    MS-Off Ver
    Excel 2007
    Posts
    249

    Need a 12 month rolling value

    I need a 12 month rolling number.

    I need it to calculate a 12 period from the current date on the summary tab.

    It can either go by the 12 months on the summary tab or by the 2012 and 2013 tabs and go by days.Attendance.xlsx

    so if bob gets 2 points in January and 1 in july. Next January those 2 points will fall off and then he will be down to 1 point until july.

    Here is a sample

    Thanks

  2. #2
    Forum Contributor
    Join Date
    02-02-2012
    Location
    Michigan
    MS-Off Ver
    Excel 2007
    Posts
    249

    Re: Need a 12 month rolling value

    =SUM(OFFSET($J$4,,ROWS($J$4:J4)-1,1,12))

    Would this work? I have it set up and it is calculating right but will this move next month so it stays accurate or will I have to adjust it again?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Rolling 24 month graph
    By shido in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 11-02-2010, 08:14 AM
  2. 13 month rolling chart
    By edhughes8 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-11-2008, 09:16 AM
  3. Rolling month
    By wyotechpro in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-15-2008, 04:08 PM
  4. Rolling 12 Month
    By Reefaman in forum Excel General
    Replies: 2
    Last Post: 01-23-2007, 08:37 AM
  5. [SOLVED] How do I set up 12-month rolling month cells in excel?
    By jbh in forum Excel General
    Replies: 2
    Last Post: 11-30-2005, 04:15 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