Tom’s Tutorials For Excel: Summing Every Nth Cell
Here’s an array formula that allows you to sum every Nth cell, where “N” is the interval number between cells. In the pictured example, you see that every 7 cells are summed in the budget worksheet with the array formula
You are not limited to the
SUM function. To average every 7 cells, modify the formula as
Recall, an array formula is applied to the cell by pressing
Ctrl+Shift+Enter, not just
If you are unfamiliar with array formulas, see my video and explanation of arrays here.