Average Cells for the last 12 months only?

[kbdavis]

I am wanting to average my electric bill for the past year only, but I want to keep all the history in excel.

In my workbook, I have many sheets, but there are only two that matter. "Sheet1" is the main sheet where the formula will be listed, the other sheet, "OG&E" is where the billing history will be located.

So, what I would like to do is average the numbers in "OG&E!C:C", only averaging the most 12 recent dates in column "OG&E!A:A", and returning the formula result to "Sheet1!B8".

Thank you for the help!

 

[Aladin Akyurek]

Try something like...

=AVERAGE(OFFSET(INDEX(OG&E!C:C,MATCH(9.99999999999999E+307,OG&E!C:C)),0,0,-12))

 

[kbdavis]

Try something like...

=AVERAGE(OFFSET(INDEX(OG&E!C:C,MATCH(9.99999999999999E+307,OG&E!C:C)),0,0,-12))

That seems to work perfectly. Thanks for the help!

 

[Aladin Akyurek]

That seems to work perfectly. Thanks for the help!

You are welcome.