Create a SUM of cells horizontally

[Henn9660]

Good Morning All! I am trying figure out how I can create a SUM using
horizontal cells. I have cells B3 through AX3 containing dollar amounts. I
would like to have a total calculated and placed into cell AY3, without
having to type 20 miles of "plus signs" via a typical formula.

Next, I would want to take that calculated value from AY3 and reflect it in
cell at B4, the row BELOW.

My spreadsheet is 176 rows long, and will grow inevitably, so doing a
formular long-hand would lead to carpal tunnel as well as crossed-eyes by the
time I finished.

Any shortcuts would be most welcomed! In advance, thanks. Jeff

 

[Brad]

In cell ay3 enter the following
=sum(B3:ax3)
In cell b3 enter the following
=ay3

 

[Pete_UK]

Put this formula in AY3:

=SUM(B3:AX3)

then you can copy this down to row 176. In B4 you can put this
formula:

=AY3

and then copy this down.

Hope this helps (your eyesight).

Pete

 

[Henn9660]

It worked perfectly. MANY thanks. Jeff

In cell ay3 enter the following
=sum(B3:ax3)
In cell b3 enter the following
=ay3

 

[Henn9660]

Pete, thanks as well! Jeff

Put this formula in AY3:

=SUM(B3:AX3)

then you can copy this down to row 176. In B4 you can put this
formula:

=AY3

and then copy this down.

Hope this helps (your eyesight).

Pete

 

[Pete_UK]

You're welcome, Jeff - thanks for feeding back.

Pete