Autosum row

Originally Posted by drdoom

I am writing a excel document containing large amounts of data. Excel is currently giving me a hard time with automaticly sum the cells in each row. For exampel:

A B C D E F
1 2 3 4 5 15

I want column F to always autosum column A - E, without having to press autosum for each row. Summing several rows at a time doesn't work either as I have to check that the sum after each row is correct as I enter them.

Thanks in advance

try simply following formula in column F

=SUM(A1:E1)

Hi,

Just to add you can use the fill handle to drag the formula down lots of rows

http://www.mvps.org/dmcritchie/excel/fillhand.htm

VBA Noob