Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to check for Horizontally merged cells | Excel Discussion (Misc queries) | |||
How to create a floating bar chart vertically not horizontally... | Charts and Charting in Excel | |||
how to align vertical cells horizontally | New Users to Excel | |||
How to copy cells horizontally to cells out of sequence | Excel Discussion (Misc queries) | |||
Move cells vertically to horizontally | Excel Discussion (Misc queries) |