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. #3
    Forum Expert Kevin UK's Avatar
    Join Date
    12-07-2010
    Location
    Radstock, Somerset
    MS-Off Ver
    365
    Posts
    1,922

    Re: Last 12 month's average

    Hi simonlblea

    Try the Index & Match (Non volatile)
    Formula: copy to clipboard
    =AVERAGE($A3:INDEX(3:3,MATCH("Rolling average",$1:$1,0)-1))


    Or
    Formula: copy to clipboard
    =AVERAGEIF($A3:INDEX(3:3,MATCH("Rolling average",$1:$1,0)-1),">0")

    If you need to exclude zero values when averaging.
    Last edited by Kevin UK; 03-26-2013 at 08:55 AM.
    Regards Kevin


    Merged Cells (They are the work of the devil!!!)

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