Create a SUM of cells horizontally

H

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
 
P

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
 
H

Henn9660

Pete, thanks as well! Jeff

Pete_UK said:
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
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting number of cells that make up a sum.. 2
Sum column of cells that already contain a formula 2
Finding a sum by matching two cells with the same identifier 1
Sum of cells when an #N/A is present 3
return a minimum value of 1, except when multiplied by an empty ce 6
Need to create a SUM for data in a row of cells containing IF fun. 1
How to get total "conditional sum of cells" in a column? 5
Create a conditional formula to change the value of other cells 1

Top