Skydiver,

Maybe trying this code will work out better for you, place into G2.

=IF(G1="","",IF(F2+G1=G1,"",F2+G1))

--
--Thomas [PBD]
Working hard to make working easy.


"Skydiver" wrote:

Okay I did this, but I don't want the running totals to appear until I place
the previous figure in. In other words, I've copied the formula all the way
down to where I need it, but the running totals are displayed all down that
column.

"Thomas [PBD]" wrote:

Skydiver,

One thing you could do is:
Place =F1 in G1
Place =G1+F2 in G2
Copy G2 to the length of your records.

In essence, this will do the following:
F G
100 100
200 300
300 600
400 1000



--
--Thomas [PBD]
Working hard to make working easy.


"Skydiver" wrote:

I have a figure in F1. In G1 is a copy of F1. I want to continue entering
figures in my F column and have a running total in the G column beginning in
G2, however...I don't want the figures to appear until I put a figure in the
previous F cell. I hope this makes sense. Please help.