Hello.

I have data in one very long column (approx. 14000 cells).

I would like to sum the values in this column in groups of 12 cells (i.e. sum cells 1-12, sum cells 13-24, etc).

I've tried the SUMIF function but the auto-complete feature when dragging the formula down the column doesn't reference consecutive groups of 12 cells.

Any help would be appreciated.

Thanks.