+ Reply to Thread
Results 1 to 3 of 3

Help With Rolling 6-Month Sum

  1. #1
    Registered User
    Join Date
    06-15-2017
    Location
    Charlotte, NC
    MS-Off Ver
    MS 2016
    Posts
    2

    Help With Rolling 6-Month Sum

    Hi,

    I have created an Excel sheet to track employee absences, with different reasons for absences being quantified with a specific amount of points (i.e., Tardy=1/4 point, Partial Day=1/2 point, Full day=1 point, etc.). I have to create a rolling six month sum, or total, for the number of points accumulated by each employee, and I am trying to create this in the "Total Points" Column . I have attached a picture of my spreadsheet. Please help!!

    IMG_7953_1.jpg
    Last edited by mdevane0926; 06-15-2017 at 06:58 PM.

  2. #2
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Excel 2007 & 2003
    Posts
    2,887

    Re: Help With Rolling 6-Month Sum

    Try with in "N4"
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    atul


    If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.

    Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".

  3. #3
    Registered User
    Join Date
    06-15-2017
    Location
    Charlotte, NC
    MS-Off Ver
    MS 2016
    Posts
    2

    Re: Help With Rolling 6-Month Sum

    You, my friend, have just made my day. This formula works perfectly! Thank you so much!

+ 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. [SOLVED] Create dynamic rolling 3 month data that increases in one month increments
    By v_pilling in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 03-24-2017, 01:33 PM
  2. Replies: 3
    Last Post: 11-11-2016, 07:46 PM
  3. Replies: 3
    Last Post: 07-16-2014, 02:53 PM
  4. Need a 12 month rolling value
    By srgtennis in forum Excel General
    Replies: 1
    Last Post: 07-17-2013, 11:00 AM
  5. Rolling month
    By wyotechpro in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-15-2008, 04:08 PM
  6. Rolling 12 Month
    By Reefaman in forum Excel General
    Replies: 2
    Last Post: 01-23-2007, 08:37 AM
  7. [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

Tags for this Thread

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