+ Reply to Thread
Results 1 to 4 of 4

Struggling with using OFFSET formula for rolling averages

  1. 05-29-2013, 05:06 PM #1
    greykitten
    greykitten is offline
    Registered User
    Join Date
    05-15-2013
    Location
    Portland,OR
    MS-Off Ver
    Excel 2010
    Posts
    6

    Struggling with using OFFSET formula for rolling averages

    Hello,
    I need to calculate the rolling average of a large list of metrics. I've figured out how to create an offset formula to return a rolling 3,6,12 & 36 month average for one metric but it doesn't work when I try to copy and paste that same formula to subsequent metrics underneath. Is there a way that I can modify this offset formula so it will return rolling averages for a long list of metrics? Here is a link to the file I'm struggling with. Thank you so much in advance for your help!

    File link: <a href="https://hotfile.com/dl/224975865/c759a62/Rolling_Ave_OFFSET_Question.xlsx.html">https://hotfile.com/dl/224975865/c759a62/Rolling_Ave_OFFSET_Question.xlsx.html</a>

    Thank you!
    Eric
    Reply With QuoteRegister To Reply
  2. 05-29-2013, 06:38 PM #2
    oeldere
    oeldere is offline
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Struggling with using OFFSET formula for rolling averages

    You get better help if you add your excel file on this forum, without confidentional information.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.
    Reply With QuoteRegister To Reply
  3. 05-29-2013, 06:56 PM #3
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,926

    Re: Struggling with using OFFSET formula for rolling averages

    Instead of using offset(), take a look at using averageifS()...
    =averageifS(average_range,date_range,">="&1st_date,date_range,"<="&end_date)
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    Reply With QuoteRegister To Reply
  4. 05-30-2013, 10:31 AM #4
    greykitten
    greykitten is offline
    Registered User
    Join Date
    05-15-2013
    Location
    Portland,OR
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Struggling with using OFFSET formula for rolling averages

    Dear oeldere,
    The values were fabricated thus it wasn't confidential information. But thanks for the input.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1