MS Excel help required

[CircleFaust]

hi

i want column F to calculate the total miles (out + return) once i have typed them into column D and E. i would like it to do this automatically for all cells in column F
can it be done?
ta

 

[modo77]

Just click in the F6 box and on the square in the bottom right and drag it all the way down. If you've got the formula in F6 it will duplicate it.

 

[$c8t@]

just type

=sum(D5:E5) in Cell F5

then once youve done that, grab the little square bottom right and drag it down, this will then enter the correct formula for all the other cells

 

[CircleFaust]

thanks lads