Hi all,
I am getting rather frustrated by what seems to be a fairly straight forward task.
I am wanting to calculate the average of the last 7 entries across a row that will be added to. I have seen many formulas calculating downwards, and I have managed to accomplish this- but the formula needs to be calculating across the row, opposed to down a column and I am definitely missing something!
Is a Sample of what I am trying to achieve.
7day Average
2 3 1 4 5 1 4 5 5
This is where I last got to before getting too annoyed!
=AVERAGE(OFFSET(K41,COUNTA(L41:S41)-7,0,7))
So; the range will be added to, and I am, wanting to calculate the average of the last 7 entries- overwriting the previous one
There will be no blank fields ( the numbers will run continuously)- but there is other text in the workbook, within that row.
Any help will be much, much appreciated!!! :D :D :D
Bookmarks