Greetings everyone and thank you in advance :-)
I need a formula .
Range D10 to XC10
In XD10 I need a formula to sum values every 6 columns
( D10+J10+P10 and so on)
I tried "=SUM(IF(MOD(COLUMN(D$10:XC$10),6 = 1,D10:XC10,0)))" (CTRL_SHIFT_ENTER)
Excel gives me error and the error highlited is ",6"
In XE10 I will need the same but starting from E10
Bookmarks