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.
Bookmarks