moving average

[Excelski]

Hello All,
I am tracking kilometres driven per month, I want to see the average for the year at the end of each month.
I can get the average with the help of helper cells. See attached. However with this method you have to keep adjusting the cell reference to accommodate the new months as the data is added.
Is it possible to write this into one cell, without adjusting it as data is added through the year
Thanks
Kevin

[BadlySpelledBuoy]

Is this of any use to you?

AVERAGEIF is your friend here. I've also slightly amended the formulas in S5:AD5

BSB

[Excelski]

BSB,

Many thanks for your help, is it possible to do away with the helper cells?

Thanks
Kevin

[BadlySpelledBuoy]

Try the below in cell Q5

Please Login or Register  to view this content.

BSB

[Phuocam]

Another way...

=AVERAGE(IF(D5:O5="","",D5:O5-C5:N5))

Enter with Ctrl+Shift+Enter

[Excelski]

Thank you BSB & Phuocam very helpful!

[Phuocam]

You are welcome!