Forum Discussion

ahmad ali's avatar
ahmad ali
Brass Contributor
Jan 05, 2019
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 ...
excel
  • SergeiBaklan's avatar
    SergeiBaklan
    Jan 05, 2019

    Hi,

     

    That could be

    =SUMPRODUCT(A2:F2*ISODD(COLUMN(A2:F2)))
and
=SUMPRODUCT(A2:F2*ISEVEN(COLUMN(A2:F2)))

     

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jan 05, 2019

Hi,

 

That could be

=SUMPRODUCT(A2:F2*ISODD(COLUMN(A2:F2)))
and
=SUMPRODUCT(A2:F2*ISEVEN(COLUMN(A2:F2)))

 

ahmad ali's avatar
ahmad ali
Brass Contributor
Jan 05, 2019

Dear Sergei Baklan, 

 

Thank you so much 

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Jan 05, 2019

    Ahmad, you are welcome