Rolling average

[ssh99]

I need a rolling average in cell AA4-AA6 for data from the last 6 months covering columns C to Z.

Each month data may be added to the next column which is why I have specified a range.

There are some months where there is no data available.

The spreadsheet can be accessed on the following link: Template.xlsx

Any help would be grately appreciated! I've been searching for a solution using the OFFSET formula for hours but it is not working,

 

[kevin9999]

I tested the code again on the Template you provided (saved as macro-enabled file) and the code from post #2 works fine for me. I've attached a link to the file for you to try.

Template.xlsm

I only typed the function into the first 2 cells. Please try typing the formula:

=AVG6M()

into cell AA6 and let me know if it works for you.

 

[ssh99]

Yes, it's opening, but I assume you saved it in macro enabled or binary format after you added the code?

Yes, same error still comes up.

 

[ssh99]

I tested the code again on the Template you provided (saved as macro-enabled file) and the code from post #2 works fine for me. I've attached a link to the file for you to try.

Template.xlsm

I only typed the function into the first 2 cells. Please try typing the formula:

=AVG6M()

into cell AA6 and let me know if it works for you.

That worked, thank you!!!

 

[kevin9999]

That worked, thank you!!!

Glad we finally found a solution