| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help!
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Help!
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Help!
Enter
=F1 in G2 Enter =IF(F2<"",F2+G2,"") in G3 and copy down... "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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Help!
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. "Sheeloo" wrote: Enter =F1 in G2 Enter =IF(F2<"",F2+G2,"") in G3 and copy down... "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. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Help!
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. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Help!
Perfect! Thank you, thank you, thank you!!!!!!!!!!!!!!!!!!!!!!!!
"Sheeloo" wrote: Enter =F1 in G2 Enter =IF(F2<"",F2+G2,"") in G3 and copy down... "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. |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Help!
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... "Thomas [PBD]" wrote: 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. "Sheeloo" wrote: Enter =F1 in G2 Enter =IF(F2<"",F2+G2,"") in G3 and copy down... "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. |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Help!
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. |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Help!
Okay, this one worked. Yeaaaaaaahhhh! Thank you guys. You all are
lifesavers!!! "Sheeloo" wrote: 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... "Thomas [PBD]" wrote: 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. "Sheeloo" wrote: Enter =F1 in G2 Enter =IF(F2<"",F2+G2,"") in G3 and copy down... "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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
