👍 INDEX and the Seven-Day Rolling Average Liked The double index formula can be used to create a rolling average, by wrapping this double index with a standard AVERAGE function: =AVERAGE(INDEX(A2:A,COUNTA(A2:A)-6):INDEX(A2:A,COUNTA(A2:A))) pic.twitter.com/WA9GWQMk0W — Ben Collins (@benlcollins) July 16, 2021
