Results 1 to 5 of 5

Need my Rolling 12 function to reference a month in one cell but the year in another cell

Threaded View

  1. #1
    Registered User
    Join Date
    06-04-2013
    Location
    Canada
    MS-Off Ver
    Excel 2007
    Posts
    18

    Need my Rolling 12 function to reference a month in one cell but the year in another cell

    Currently My Rolling 12 formula is =SUM(OFFSET(Data!$D$6,0,MATCH($B$8,Data!$D$4:$ET$4,1)-1,1,-12)). Cell B8 is a date in the form of 'May-13'. I want the rolling 12 to recognize that month ONLY and for it to reference the year entered in another cell. Attached is a sample of my document, notice how when you change the years on the summary tab, everything auto changes and streams perfectly except for my rolling 12.

    There is a comment in the document with simpler instructions..

    Thank you!

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