Get a skip total

An Excel file that teaches how to perform Skip Line Total Sum operation.

Excel Get A Skip Total

SUMPRODUCT or INDIRECT functions are used. The number of steps is turned into a parameter. Selection is made with array formulas. The example template shows the logic of skipping lines. The solution is used on periodic data.

Hope it is useful.