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