I have a column with about 1000 rows and I want to find the average for every 16 rows and add it in the next column without empty cells between them. I found this formula, which works perfect if my data starts from the first row.
I am trying to make it work for data that starts from the second row, since the first row has the headers. I tried a lot of things without success. Any help?