Calculate Rolling Average - Skipping Columns

[FalconFlyer]

I am trying to calculate a rolling 12 month average. The hard part is I need to keep a column ("Total" column).

I am not sure the easiest way around this. I'm assuming OFFSET can be used, but am looking for ideas.

TIA

May 2017	Jun	Jul	Aug	Sep	Oct	Nov	Dec	Total	Jan 2018	Feb	Mar	Apr
1	2	2	3	5	10	12	10	45	1	5	5	2

<tbody>
</tbody>

 

[jtakw]

Hi,

If you have the AVERAGEIF function:

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec	Total	Jan	Feb	Mar	Apr		12 Month Avg.
2	Jul-05									Jul-05
3	1	2	2	3	5	10	12	10	45	1	5	5	2		4.833333333
Sheet54

Cell Formulas
Range	Formula
O3	=AVERAGEIF(A1:M1,"<>"&"Total",A3:M3)

 

[FalconFlyer]

Hi,

If you have the AVERAGEIF function:

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec	Total	Jan	Feb	Mar	Apr		12 Month Avg.
2	Jul-05									Jul-05
3	1	2	2	3	5	10	12	10	45	1	5	5	2		4.833333333

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet54​

Worksheet Formulas Cell Formula O3 =AVERAGEIF(A1:M1,"<>"&"Total",A3:M3) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

I apologize for the delay. That is exactly what I was looking for. I did not even think of AVERAGEIF. Thank you!

 

[jtakw]

You're welcome.