Jan 05 2019 06:49 AM
Hello,
I need to add the odd columns (A,C and E) and put the result under Total in
and add the even columns (B,D and F) and put the result under Total out
I have to use MOD function .... thanks
I've tried ( =SUMIF(A2:F2;MOD(COLUMN(A2);2)<>0;A2:F2) ) but it's not working?
could you please fix my formula? thanks
Jan 05 2019 07:13 AM
SolutionHi,
That could be
=SUMPRODUCT(A2:F2*ISODD(COLUMN(A2:F2))) and =SUMPRODUCT(A2:F2*ISEVEN(COLUMN(A2:F2)))
Jan 05 2019 08:10 AM - edited Jan 05 2019 08:11 AM
Dear Sergei Baklan,
Thank you so much
Jan 05 2019 07:13 AM
SolutionHi,
That could be
=SUMPRODUCT(A2:F2*ISODD(COLUMN(A2:F2))) and =SUMPRODUCT(A2:F2*ISEVEN(COLUMN(A2:F2)))