Forum Discussion
Solved
I need to use MOD function
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 ...
Hi,
That could be
=SUMPRODUCT(A2:F2*ISODD(COLUMN(A2:F2))) and =SUMPRODUCT(A2:F2*ISEVEN(COLUMN(A2:F2)))
Dear Sergei Baklan,
Thank you so much
Ahmad, you are welcome