Sum range of cells depending the value of another cel

[jvgjvg77]

Hi,

I'm trying to automate an excel file.

I have a range of 53 columns where i want to count the range of A1+B1 iff the value is 2, and so it has to continue to the right B1+C1

If the value is 10 the sum has to be A1:J1 and for the next cell in the row B1:K1

Does anyone have a formula for that?

Thanks in advance.

Jens

[samba_ravi]

Next Cell Means it moves towards down or towards right
please attach sample file with desired result if possible

[jvgjvg77]

Hi Siva,

Thanks for your answer, i attached an example to this post.

Hope you can come up with something?

Thanks

excel.xlsx

[samba_ravi]

N2=IFERROR(SUM(A2:INDEX(A2:$J2,ROWS(N$2:N2)*2)),"")
Try this and copy across

[jvgjvg77]

Hi Siva,

I tried it on both English and Dutch excel versions but keep getting this error?

error excel1.jpg
error excel2.jpg

[popipipo]

=IFERROR(SUM(A2:INDEX(A2:$J2;ROWS(N$2:N2)*2));"")
Try it this way

[jvgjvg77]

Thanks for the help but now it gives me the following error (in dutch)

#NAAM?

[popipipo]

Formule even vertalen (translate it)

http://dolf.trieschnigg.nl/excel/index.php

[jvgjvg77]

Thanks, translation helped and i adjusted the formula a little bit and now it works

=IFERROR(SUM(A2:INDEX(A2:$J2;$L2));"")