Add number from cell reference to other cell formular.

[KSveigaard]

Hi All.

This might be simple but today I canīt figure it out.

I need to have a cell ference that extends with the number from another cell.

I cell B10 formel: "=SUM(A50:A50)"

Where the last A50 need to be incresed with the bumber in cell B1.

So if B1 is 1 the formel would be "=SUM(A50:A51)"
So if B1 is 5 the formel would be "=SUM(A50:A55)"
So if B1 is 0 the formel would be "=SUM(A50:A50)"

Is that possible ???

[Fluff13]

How about

Please Login or Register  to view this content.

[Glenn Kennedy]

You did not say what you want to happen if B1 is 0 or blank... so maybe this:


=SUM(A50:INDEX(A50:A1000,B1+1))

[wk9128]

=sum(indirect("a50:a5"&$b$1))

[KSveigaard]

SOLVED - THANKS - SO SIMPLE - It is just to hot today ;-)

[Fluff13]

Glad to help & thanks for the feedback.