S KRISHNASWAMYCopper ContributorNov 17, 2020summing alternate column or rowI want add only alternate columns and get sum total.
1 ReplyReplies sorted by NewestSergeiBaklanDiamond ContributorNov 17, 2020S KRISHNASWAMY That could be something like =SUMPRODUCT( range*(MOD(COLUMN(range),2)=1))
SergeiBaklanDiamond ContributorNov 17, 2020S KRISHNASWAMY That could be something like =SUMPRODUCT( range*(MOD(COLUMN(range),2)=1))
