One way to get those averages is to use this formula in B1 copied down
=AVERAGE(OFFSET(A$1,(ROWS(B$1:B1)-1)*3,0,3))
One way to get those averages is to use this formula in B1 copied down
=AVERAGE(OFFSET(A$1,(ROWS(B$1:B1)-1)*3,0,3))
Audere est facere
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks