Equation that doesn't calculate unless ALL relevant values are present

[Natejss]

I'm creating a ledger with a "Coins Remaining" value in column J that is dependent upon the most recent value of "Coins In/Out (+/-)" in column I. Simply stated each value in J is equal to the sum of the cells directly to the left and directly above (J9=I9+J8).

This function is simple but I'd like to perpetuate the entire "Coins Remaining" column with this formula in such a way as to only calculate when there actually IS a value in I, and NOT when it is empty. Essentially, if there is no corresponding value in the "Coins In/Out (+/-)" column, I would like the same to be true of the "Coins Remaining" column as well.

Is this possible?

[JohnTopley]

Attach a sample workbook (not image).

Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate.

Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[Natejss]

Done and done. I hope this helps.

[FlameRetired]

Try this in J7 and fill down.

Please Login or Register  to view this content.

[Natejss]

Thanks. That did the trick. You're a champ!

[FlameRetired]

You're welcome. Thanks for the feedback, rep and marking your thread Solved.