auto sum?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

filling in data in each row left to right. at end of row is the total cloumn.
trying to figure out right formula to auto calculate and also at the bottom
of the total column. does anyone know how this is done?
 
this will sum columns A to J in row 1
=SUM(A1:J1)

this will sum rows 1 to 10 in column A
=SUM(A1:A10)

You'll find a good explanation of the SUM function in the Excel help.
Search for "SUM worksheet function"
 
selecting an empty cell at the bottom of the row or column and pressing
auto-sum button is a nice shortcut
 
yes to all who reply this is what i have:

Rent Non Food Clothing Utilities Bus Total
$200.00 $40.00 $35.00 0
$25.00 $300.00
row
row
Total Total Total Total
Total Total

with 300.00 the total of that row and to the far right (same row) is
fname,lname (same cell). i wanted to auto sum at the end of row and auto sum
at the end of each column especially the total colum.

Second, if the first cell is fname,lname if I a-z that column how will the
other columns be affected?

Thanks to all you have replied.
 
Back
Top