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

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

Excel automatically modifies cells; so if in G1 you have =SUM(E1:F1) and you
copy (by dragging it) this formula to G2 it will read =SUM(E2:F2) - I think
you have a typo in your question.

Further points:
1) You do not need SUM; for a simple formula like this I would use =E1+F1
2) If there is data in column F when you type in G1, you can double click
G1's fill handle (little solid square in lower right of selected cell) to
automatically copy the formula down
or
3) If you select, say G1:G100, type the formula and then press CTRL+ENTER
you will fill the entire range with the required formulas

best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"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

Sorry, I wasn't quite clear enough. I'm looking for a wee bit of code I
can jst place in the middle of a macro to do this for automatically?

Cheers


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

Any use:
Sub Macro1()
Range("G1").Select
ActiveCell.FormulaR1C1 = "=RC[-2]+RC[-1]"
Selection.AutoFill Destination:=Range("G1:G26")
End Sub

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"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

Cheers much


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