auto sum?

T

teddkilroy

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?
 
V

Vergel Adriano

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"
 
M

Mike

selecting an empty cell at the bottom of the row or column and pressing
auto-sum button is a nice shortcut
 
T

teddkilroy

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.
 
Top