Forum Discussion
Formula for adding non-consecutive cells across entire row
Hoping someone can help; I'm trying to automatically add non-consecutive cell values together and am currently using the old fashioned approach of SUM(cell1, cell7, cell13...). The pattern remains th...
If to sum every 6th cell in first row, it could be
=SUMPRODUCT(IF(MOD(COLUMN(INDEX(1:1,0,FirstColumn):INDEX(1:1,0,LastColumn))-FirstColumn,Period)=0,INDEX(1:1,0,FirstColumn):INDEX(1:1,0,LastColumn),0))
where FirstColumn, LastColumn and Period are named cells with parameters. Similar if every 6th cell in the column.