Formula doesn't continue when new row to table is added

[kctony]

I have a running inventory table with a formula that either adds or subtracts and calculates a current balance. When I add a new row either manually or by the use of a form, a row will generate but the formula won't function and I get a #REF .
Any thoughts?
I've looked for many solutions but nothing seems to address my situation.
Thanx

below is the formula... I can't past or insert the table in here...

=IF(AND($F7<>"",$G7<>""),($G7+$J6),IF(AND($F7<>"",$G7=""),($J6-$I7)))

 

[Oaktree]

Maybe INDIRECT?

INDIRECT("F7") will always reference cell F7 regardless of whether new rows/columns are inserted...

 

[kctony]

Thank you for the response but I don't want it to reference f7.
the table will have new data (rows) added multiple times a day. I want the table to grow with each row and have the formula in the previous row move to the mnew row and calculate based on the input in that row.. I tried to use dynamic ranges but sometimes i would get a reference but most times no, so I went with cell references

 

[Oaktree]

Let me see if I understand:

It sounds like you have the formula:

=IF(AND($F7<>"",$G7<>""),($G7+$J6),IF(AND($F7<>"",$G7=""),($J6-$I7)))

in some cell. If you insert a new line between row 6 and 7, that formula updates to

=IF(AND($F8<>"",$G8<>""),($G8+$J6),IF(AND($F8<>"",$G8=""),($J6-$I8)))

but you don't want it to. Instead, you want the 6s in that formula to update to 7s so that it always references the current row and the row immediately above it.

Is that what you mean?

If so, INDIRECT truly is the way to go. Instead of referencing cells in a row above, use INDIRECT to offset the row by -1.

=IF(AND($F7<>"",$G7<>""),($G7+INDIRECT("J"&row(G7)-1)),IF(AND($F7<>"",$G7=""),(INDIRECT("J"&row(G7)-1)-$I7)))

 

[kctony]

Thank you,
That is a thing of beauty...
I admit I am not too familiar with 'Indirect' and couldn't quite wrap my head around it but that did the trick!.
I was trying INDEX wit not very good results.
Anyway, thank you agian... much appreciated