Results 1 to 4 of 4

Thread: 2 Week Rolling Average

  1. #1

    2 Week Rolling Average



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I am pretty basic when it comes to Excel 2010.

    I need help determing a rolling average for the past two weeks in column L on the WOH tab for every 2 columns labeled "COMP" on the Completed Work tab.

    I do not want to see lovely DIV/0! error however zeroes must be included in the 2 week calculation if any, ignoring the blanks.

    I'm not sure if a helper column is needed on the Completed Work tab in order to calculate the rolling average.
    I have tried different suggestions from google and assorted tutorials but I would assume I'm not inputting the formulas correctly...
    Attached Files Attached Files

  2. #2
    If I insert a column to the left of the Sun 11/1 data, and insert the following array formula


    =AVERAGE(IF(MOD(COLUMN(C4:GF4)-COLUMN(C4),3)=0,IF(C4:GF4>0,C4:GF4)))


    I get the average for every third column just fine... But I just want to see the average for the past two weeks based on today's date starting in WOH!L3; not an average of all the data in every third column.

  3. #3
    Wizard Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,615
    Articles
    0
    Excel Version
    2010 on Xubuntu
    Does the attached help ?
    Copy of TESTER2.xlsx

  4. #4
    Quote Originally Posted by Pecoflyer View Post
    Does the attached help ?
    Copy of TESTER2.xlsx
    It does, thank you much!!!!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •