software

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: www.excelforum.com/member.php...oamp;userid=24895
View this thread: www.excelforum.com/showthread...hreadid=498373Yes. 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 quot;drag downquot; the formula as far as you wish.

--
Kind regards,

Niek Otten

quot;Hru48quot; gt; wrote in
message ...
gt;
gt; Hey all,
gt;
gt; Is there a way that I can put the formula of SUM(E:F) through the whole
gt; of column G (result field) automatically.
gt;
gt; eg so cell G1 would be SUM(E1:F1)
gt; G2 would be SUM(G2:F2)
gt;
gt; etc.
gt;
gt; many thanks
gt;
gt; Hayley
gt;
gt;
gt; --
gt; Hru48
gt; ------------------------------------------------------------------------
gt; Hru48's Profile:
gt; www.excelforum.com/member.php...oamp;userid=24895
gt; View this thread: www.excelforum.com/showthread...hreadid=498373
gt;
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

quot;Hru48quot; gt; wrote in
message ...
gt;
gt; Hey all,
gt;
gt; Is there a way that I can put the formula of SUM(E:F) through the whole
gt; of column G (result field) automatically.
gt;
gt; eg so cell G1 would be SUM(E1:F1)
gt; G2 would be SUM(G2:F2)
gt;
gt; etc.
gt;
gt; many thanks
gt;
gt; Hayley
gt;
gt;
gt; --
gt; Hru48
gt; ------------------------------------------------------------------------
gt; Hru48's Profile:
gt; www.excelforum.com/member.php...oamp;userid=24895
gt; View this thread: www.excelforum.com/showthread...hreadid=498373
gt;

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: www.excelforum.com/member.php...oamp;userid=24895
View this thread: www.excelforum.com/showthread...hreadid=498373Any use:
Sub Macro1()
Range(quot;G1quot;).Select
ActiveCell.FormulaR1C1 = quot;=RC[-2] RC[-1]quot;
Selection.AutoFill Destination:=Range(quot;G1:G26quot;)
End Sub

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

quot;Hru48quot; gt; wrote in
message ...
gt;
gt; Hey all,
gt;
gt; Is there a way that I can put the formula of SUM(E:F) through the whole
gt; of column G (result field) automatically.
gt;
gt; eg so cell G1 would be SUM(E1:F1)
gt; G2 would be SUM(G2:F2)
gt;
gt; etc.
gt;
gt; many thanks
gt;
gt; Hayley
gt;
gt;
gt; --
gt; Hru48
gt; ------------------------------------------------------------------------
gt; Hru48's Profile:
gt; www.excelforum.com/member.php...oamp;userid=24895
gt; View this thread: www.excelforum.com/showthread...hreadid=498373
gt;

Cheers much--
Hru48
------------------------------------------------------------------------
Hru48's Profile: www.excelforum.com/member.php...oamp;userid=24895
View this thread: www.excelforum.com/showthread...hreadid=498373