Summing rows

  • Thread starter Thread starter Richard
  • Start date Start date
R

Richard

I've got Excel 97. It's easy to arrange summation of data in a column of
cells. You put in a result cell the summation formula for every column you
want to sum. You can use the same formula for summation in rows, but do you
have laboriously enter, one cell at a time, the regular summation formula.
If I had 200 rows, I'd have to enter the required formula 200 times. Cannot
I just highlight the column which contains the summations and do something,
so that each cell in the column will end up containing the row summation?
TIA?
 
Hi Richard
try something like the following in column A, cell A1
=SUM(B1:IV1)
and copy this formula down
 
Have you tried to move the cursor to the lower right corner of the cell
with the first formula then double click it.? If the formula is not in an
adjacent column use the fill handle and copy down 200 rows..
 
Richard, of course you don't have to enter 200 formulas one after the other!

Do the formula in the first cell, then Edit > Copy. Select the other 199
cells and Edit > Paste.
OR
Do the formula in the first cell, then grab the "fill handle" (lower right
corner of the cell pointer), and drag to copy the formula to the other 199
cells.
OR
Select all 200 cells, type your formula, press Ctrl-Enter.
OR
Select all 200 cells and click the AutoSum button on the toolbar.

DDM
"DDM's Microsoft Office Tips and Tricks"
www.ddmcomputing.com
 
DDM said:
Do the formula in the first cell, then grab the "fill handle" (lower
right corner of the cell pointer), and drag to copy the formula to
the other 199 cells.
Click to expand...

Brilliant! Fantastic! Cheers!
 
Back
Top