Suppose there is a column of data points. We want a new column of data points which consists of the sums of every n data points in the old column continuously. For example, if there are 1000 data points in the old column, and we want every 5 data points to be summed up to a new data point, there will be 200 data points in the new column.

The formula to use is `=SUM(OFFSET(r,(ROW()-s)*n+s-ROW(),0,n,1))`

or `=SUM(OFFSET(r,(n-1)*(ROW()-s),0,n,1))`

, where `r`

is the reference and `s`

is the row of the first data point. See the screenshot below.

## Post new comment