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"


"teddkilroy" wrote:

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?