+ Reply to Thread
Results 1 to 1 of 1

Formula for Rolling Average from Multiple Worksheets

  1. #1
    Registered User
    Join Date
    04-21-2012
    Location
    South
    MS-Off Ver
    Excel 2010
    Posts
    1

    Formula for Rolling Average from Multiple Worksheets

    Hello,

    I'm new to this forum. I am trying to create a moving average formula that pulls data from 2 worksheets. Worksheets are arranged using columns B1:M1 to represent January - December. Data (in %'s) begins in cells B2:M2 and each worksheet represents a year (ie. 2011,2012). I need worksheet "2012", cell "O2" to calculate a rolling average using the data pulled from worksheet "2011, cells N2,M2 (November, December) and worksheet "2012, cell B2 (January). This needs to update the 3 month rolling average as I add each month. I have the correct formula as long as the data is pulled from the same worksheet but my problem is when the data spans 2 worksheets. Any help would be greatly appreciated. I've attached (hopefully) an example of my spreadsheet.
    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)

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