+ Reply to Thread
Results 1 to 2 of 2

Excel 2007 : Excel Help? Averages of Values over Variable Terms & Start Dates

  1. #1
    Registered User
    Join Date
    06-08-2011
    Location
    houston, tx
    MS-Off Ver
    Excel 2003
    Posts
    2

    Excel Help? Averages of Values over Variable Terms & Start Dates

    I have a list of values that changes over time on a monthly or annual basis (for example June 2011 to May 2012 is $108, then June 2012 through May 2012 is $165, etc.) I need to be able to get an average of those values based on two inputs: term length in months and a start date. So, for example, I might have a 36 month term starting in September of 2011. How might I best go about organizing the data and building that formula?

    Thanks!

  2. #2
    Registered User
    Join Date
    06-08-2011
    Location
    houston, tx
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Excel Help? Averages of Values over Variable Terms & Start Dates

    bump?

+ 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