Rolling 3-month average

[Ric F]

I have a 3-Month Trend in column N to always update as new month's data are loaded into the table. currently I'm just using an "=Average(D2:F2)", but not sure if an OFFSET formula would work or if so how quite to set it up.

Any help is greatly appreciated!

Ric



A B C D E F G H I J K L M N

<o></o>	Jan-15<o></o>	Feb-15<o></o>	Mar-15<o></o>	Apr-15<o></o>	May-15<o></o>	Jun-15<o></o>	Jul-15<o></o>	Aug-15<o></o>	Sep-15<o></o>	Oct-15<o></o>	Nov-15<o></o>	Dec-15<o></o>	3 Month Trend<o></o>
Company A	$86,528	$67,270	$72,121	$109,569	$128,395								$103,362
Company B	$143,821	$150,306	$204,868	$285,120	$354,240								$281,409

<tbody> </tbody>

 

[VBA Geek]

try

=AVERAGE(OFFSET(INDEX(B3:M3,MATCH(9.99E+307,B3:M3)),0,-2,1,3))

 

[Jonmo1]

Try

=IFERROR(AVERAGE(OFFSET(INDEX(B2:M2,MATCH(9.99999999999999E+307,B2:M2)),0,-2,1,3)),B2)

 

[Ric F]

That worked perfectly! Thanks for your help!!

 

[Jonmo1]

You're welcome.