How do I calculate a rolling average for the last 4 cells(that are weeks with Dates)? Thank you

geo33 · 09/02/21

Paul Newcome · 09/02/21

So basically you want to look across the rows and average together the four rightmost cells that have numbers in them within that same row?

Paul Newcome · 09/02/21

Are you averaging across the rows or down a specific column?

geo33 · 09/02/21

Hi Paul, thank you for helping. I am trying to average across the rows.

Paul Newcome · 09/02/21

So basically you want to look across the rows and average together the four rightmost cells that have numbers in them within that same row?

geo33 · 09/03/21

Yes that is correct

Best Answer