# Rolling 3-month average

#### Ric F

##### Board Regular
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
 Jan-15 Feb-15 Mar-15 Apr-15 May-15 Jun-15 Jul-15 Aug-15 Sep-15 Oct-15 Nov-15 Dec-15 3 Month Trend 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>

### Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!
try

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

Try

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

That worked perfectly! Thanks for your help!!

You're welcome.

Replies
4
Views
115
Replies
7
Views
329
Replies
5
Views
247
Replies
1
Views
342
Replies
0
Views
118

1,207,284
Messages
6,077,527
Members
446,287
Latest member
tjverdugo85

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back