I need to create a formula for summing cells say B2 through J2 with results
in A2 so I use the formula

=sum(B2:J2)

As you see I am summing 9 cells.

What I want to do is able to type a number in Cell A1 and sum the B2 to A1
number of cells to the right of B2.

Any help will be appreciated.