Results 1 to 13 of 13

Last 12 month's average

Threaded View

simonlblea Last 12 month's average 03-26-2013, 08:39 AM
Jonmo1 Re: Last 12 month's average 03-26-2013, 08:44 AM
Kevin UK Re: Last 12 month's average 03-26-2013, 08:52 AM
Jonmo1 Re: Last 12 month's average 03-26-2013, 08:58 AM
Kevin UK Re: Last 12 month's average 03-26-2013, 09:14 AM
simonlblea Re: Last 12 month's average 03-26-2013, 08:53 AM
Jonmo1 Re: Last 12 month's average 03-26-2013, 09:13 AM
simonlblea Re: Last 12 month's average 03-26-2013, 08:55 AM
simonlblea Re: Last 12 month's average 03-26-2013, 09:57 AM
Jonmo1 Re: Last 12 month's average 03-26-2013, 09:59 AM
simonlblea Re: Last 12 month's average 03-26-2013, 10:23 AM
Jonmo1 Re: Last 12 month's average 03-26-2013, 10:31 AM
simonlblea Re: Last 12 month's average 04-10-2013, 07:46 AM
  1. #1
    Registered User
    Join Date
    02-18-2013
    Location
    England
    MS-Off Ver
    Excel 2003
    Posts
    17

    Last 12 month's average

    Hello,

    I am trying to create a formula at the end of a row that will give an average for the past 12 months data.

    Simple enough I thought, however I am having difficulty in making the formula change each time I add a new month.

    I would like to add an extra month column to the sheet and have the average include only the new month and the previous 11 without having to manually change it.

    Attached is a document showing some of the data which will hopefully help in resolving my problem. I am using Excel 2013

    Any help would be great, thanks
    Attached Files Attached Files

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1