Hello, lets say I have 360 days of data (I insert data everyday) and I want to know what is the average of the last 8 days are. Is there a formula for that?
This is a formula I use for the last digit in the column: =LOOKUP(9.99999999999999E+307,A1:A100) Maybe there is a formula just like this but for average.
Bookmarks