Offset named range and measure the average of the named range

Hello

I have a named range called "YEARMONTHRolling12" that is dynamic code for selecting the last twelve last months.

=Offset(($F$2;0;CountA($G$2:$S$2);1;-12)

This works and when I write it in a cell it extracts the correct values in the cell like this:
2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2101

Below this values are values that I would like to count the average value from.
2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2101
1233 1233 1231 2323 2424 2424 2313 2312 2323 2314 2323 2323

I was thinking I should be able to use this formula and simply offset the dynamic range and calculate the average.

=average(Offset(YEARMONTHRolling12;Row(B3)-2;0;1;1))

However, the formula returns the value below the first column (2002 = 1233). I excepted the average of the twelve inputs.

What have I done wrong? Any ideas?

Everything written is example. See the attached file and see the cell F3 for the average formula that returns the wrong result. (Swedish original)


Kind regars
Anders

Amend to:

=AVERAGE(OFFSET(ÅRMÅNSenasteTolv,ROW(B3)-2,,,))

you were confusing it by giving it a RANGE (12 cells) from ....SeansteTolv and then telling it to look at a range 1 cell wide.

You're welcome.

---

It would be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.

Finally, if that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.