Help!

[Skydiver]

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.

 

[Thomas [PBD]]

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

 

[Sheeloo]

Enter
=F1 in G2
Enter
=IF(F2<>"",F2+G2,"") in G3 and copy down...

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.

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.

 

[Thomas [PBD]]

Sheeloo,

If you do this, then if someone has a space in say... F3 but data in F4 the
command will return #VALUE.
For Example:
100 100
200 300
300 600

500 #VALUE!

Granted, I dont know why someone would leave a space, but it could happen.

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

Enter
=F1 in G2
Enter
=IF(F2<>"",F2+G2,"") in G3 and copy down...

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.

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.

 

[Skydiver]

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.

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.

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.

 

[Skydiver]

Perfect! Thank you, thank you, thank you!!!!!!!!!!!!!!!!!!!!!!!!

Enter
=F1 in G2
Enter
=IF(F2<>"",F2+G2,"") in G3 and copy down...

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.

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.

 

[Sheeloo]

I realize that...
I normally try to give the answer which just answers the question so that
the person asking it can play around and improve upon it...

a better solution would have been to enter in G2
=IF(F1<>"",SUMIF(($F$1:F1),"<>"""),"")
and copy down...

Sheeloo,

If you do this, then if someone has a space in say... F3 but data in F4 the
command will return #VALUE.
For Example:
100 100
200 300
300 600

500 #VALUE!

Granted, I dont know why someone would leave a space, but it could happen.

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

Enter
=F1 in G2
Enter
=IF(F2<>"",F2+G2,"") in G3 and copy down...

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.


:

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.

 

[Thomas [PBD]]

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.

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.

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.

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.

 

[Skydiver]

Okay, this one worked. Yeaaaaaaahhhh! Thank you guys. You all are
lifesavers!!!

I realize that...
I normally try to give the answer which just answers the question so that
the person asking it can play around and improve upon it...

a better solution would have been to enter in G2
=IF(F1<>"",SUMIF(($F$1:F1),"<>"""),"")
and copy down...

Sheeloo,

If you do this, then if someone has a space in say... F3 but data in F4 the
command will return #VALUE.
For Example:
100 100
200 300
300 600

500 #VALUE!

Granted, I dont know why someone would leave a space, but it could happen.

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

Enter
=F1 in G2
Enter
=IF(F2<>"",F2+G2,"") in G3 and copy down...

:

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.


:

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.