Skip Line Total Sum

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

Excel Skip Line Total Sum

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.