+ Reply to Thread
Results 1 to 4 of 4

Calculating the rolling average over a year to determine the number of overdue items

  1. #1
    Registered User
    Join Date
    01-09-2020
    Location
    NEW YORK
    MS-Off Ver
    2010
    Posts
    8

    Calculating the rolling average over a year to determine the number of overdue items

    I want to calculate how many overdue items are there looking back 12 months and create a rolling average

    ROLLNG.PNG

  2. #2
    Forum Expert XLent's Avatar
    Join Date
    10-13-2010
    Location
    UK
    MS-Off Ver
    various
    Posts
    1,942

    Re: Calculating the rolling average over a year to determine the number of overdue items

    perhaps you could use something like:

    Formula: copy to clipboard
    Please Login or Register  to view this content.

    I suspect your file is using tables so you can use structured references - e.g Tbl[field]
    (if you don't use structured references then try to avoid using entire column references with COUNTIFS as it's not particularly efficient)

    If you need more assistance I'd suggest posting back and attaching a file, as opposed to an image.

  3. #3
    Registered User
    Join Date
    01-09-2020
    Location
    NEW YORK
    MS-Off Ver
    2010
    Posts
    8

    Re: Calculating the rolling average over a year to determine the number of overdue items

    Thanks for replying.

    I used structured references and my goal is to determine the number of overdue for each month.
    I implemented the formula you suggested but I had no luck.I have uploaded the excel sheet.
    Attached Files Attached Files

  4. #4
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    5,927

    Re: Calculating the rolling average over a year to determine the number of overdue items

    .
    Please Login or Register  to view this content.
    Presumably you could add a formula to count the total in Col E then divide by 12 ?
    Attached Files Attached Files

+ 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. Calculating number of sick days in a rolling year
    By nikkie456 in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 09-18-2016, 05:53 PM
  2. Calculating Number Of Sick Days In A Rolling Year - Exc
    By sansan88 in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 08-24-2015, 02:59 PM
  3. [SOLVED] Calculating Average Days overdue per department
    By greeneggsandsam in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-27-2014, 02:01 PM
  4. Formula to determine total overdue values by length of overdue
    By Midnight_Dragon in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-17-2013, 02:03 AM
  5. Calculating Five year rolling standard deviation
    By Yaaseen in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-19-2012, 02:21 AM
  6. Replies: 2
    Last Post: 03-05-2012, 03:56 PM
  7. Calculating a rolling average
    By roasthawg in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 10-16-2009, 02:45 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