Formula needed

  • Thread starter Thread starter Cerridwen
  • Start date Start date
C

Cerridwen

I have no problem getting totals for Columns B, C, and D.

=SUM(B3:B261)
=SUM(C3:C261)
=SUM(D3:D261)
=SUM(E3:E261)

These formulas total my columns

And I can get a total across ONE Row at a time

=SUM(B3:E3) this will total one row across into Column F

But I don't want to type in the formula for 261 rows in
Column F.

Any help on how to do this would be appreciated.

--

Cerridwen

"Critical thinking demands we question the unproven, not that
we meekly accept it." Diane Richardson


For Stats on Scn go to: http://www.truthaboutscientology.com/stats/
For News on Scientology go to: http://www.scientologywatch.org
 
Hi Cerridwen!

Type your formula in F3 and Enter
Check that it is doing what you want
Point to the bottom right of the cell
Double click the + sign that appears

Go out and celebrate not having to enter 257 copies of your formula

If you don't see the + sign in bottom right of the cell use:
Tools > Options > Edit
Put a check in "Allow cell drag and drop"
--
Regards
Norman Harker
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Type in the formula in the cell in column F that is in the first row of your
data. Then drag that cell (drag handle in bottom right corner) all the way
down as far as your data goes. Excel will change the row numbers
automatically. HTH Otto
 
If you want a summary cell in column F for each row, enter your

=SUM(B3:E3)

in cell F3, copy it, select F4:F261 and paste. XL will automatically
adjust the row numbers.

If you're looking for a grand total, use

=SUM(B3:E261)
 
Back
Top