I need to create a SS that calculates the yearly average from January until the end of the previous month.
Excel example.JPG
Currently I have =SUM(A2:G2)/12 and each month I go in an change the range, but I would like it to update each month to include the month that just finished.
Any help would be appreciated.
Bookmarks