Want cell to remain blank until info is entered into the cell before it

[nreed2929]

I have a chart that is suppose to calculate spending trends over the course of a year. When a number is entered into cell G5 the cell next to it (I5) reflects that number, this represents the beginning of the year. When information is entered into cell G6, the number represented in cell I6 should be the beginning of a running total for the year, the formula I currently have in cell I6 is =I5+G6. As numbers continue to be entered into the "G" column the numbers in the "I" column should grow, showing me how much I am spending each week. What I can't figure out is how to have the cells in the "I" column remain blank until information is entered into the "G" column that is beside it. Right now, what's happening is when I enter a number into G5, that number get's reflected into all of the I cells down to the end of the year. Not sure if this makes sense, wondered if anyone had any suggestions, thanks very much.

[bebo021999]

Maybe in I5 :
=G5
and in G6 then drag down:
=IF(G6="","",I5+G6)

[nreed2929]

Thanks for the quick response. I tried the formula, but am still having the same problem.

[FDibbins]

Perhaps you did not enter it correctly, or the references are wrong?
Does G6 contain an entry or a formula?

What bebo was showing, is that you need to test the "G" cell to see if it is empty, is so, answer = empty, else your formula

[nreed2929]

G6 would contain an entry (actually it's would be a formula that adds the "F" and "D" cells in the same line - i.e. in G^ it would have the formula F6+D6)Could this maybe be part of the problem?

[FDibbins]

oops, sorry, I mean "I"

can you upload a sample workbook please?

[nreed2929]

Budget Tracker with NS - 2014-2015 - Master.xls

Here is the workbook the formula I'm working with can be found on the first tab (contract 410), hope I uploaded it correctly.

[FDibbins]

thanks, makes things a lot easier

=IF(G6=0,"",I5+G6)

[nreed2929]

Thanks, that formula worked. I have to say, this forum is a HUGE help, thanks very much!!

[FDibbins]

you'r welcome. If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neat and tidy lol, and consider adding the reputation to those that helped (see points 2 & 3 below my 1st post to you)