Yes. In G1, enter =SUM(E1:F1) or simply =E1+F1
Double-click on the right-hand bottom square in cell G1. It will fill down
(and adjust) the formula as far as F is filled.
You can also manually "drag down" the formula as far as you wish.

--
Kind regards,

Niek Otten

"Hru48" wrote in
message ...

Hey all,

Is there a way that I can put the formula of SUM(E:F) through the whole
of column G (result field) automatically.

eg so cell G1 would be SUM(E1:F1)
G2 would be SUM(G2:F2)

etc.

many thanks

Hayley


--
Hru48
------------------------------------------------------------------------
Hru48's Profile:
http://www.excelforum.com/member.php...o&userid=24895
View this thread: http://www.excelforum.com/showthread...hreadid=498373