Forum Discussion
Solved
Summing the values of 3 columns apart
I have tried to use =SUM(IF(MOD(COLUMN(B3:O3),3),0,B3:O3)) to calculate the value in every 3 columns (B3, E3, H3......) and when I input (COLUMN(B3:O3),3), the value will be the sum of C3, F3, I3.......
bkbkbk01 Try it this way.
=SUMPRODUCT((MOD(COLUMN(B3:O3),3)=2)*(B3:O3))
The MOD(----, 3) function returns a value of 2 for columns B,E,H etc.
bkbkbk01 Try it this way.
=SUMPRODUCT((MOD(COLUMN(B3:O3),3)=2)*(B3:O3))
The MOD(----, 3) function returns a value of 2 for columns B,E,H etc.
FINALLY ITS WORK!!!!!
Thank you so much!!!
Thank you so much!!!