Excel Magic Trick 466: SUM every Nth value SUMPRODUCT, MOD & ROW functions

Аватар автора
Excel для учета заказов
Download Files: See how to SUM every Nth value using SUMPRODUCT, MOD and ROW functions. See two alternative formulas, each for a different situation: 1.SUMPRODUCT & MOD & ROW for range starting in cell A1 2.SUMPRODUCT & MOD & 2 ROW functions for range starting in any cell Sum every 3rd, 26th, etc. value.

0/0


0/0

0/0

0/0