I need help to create a formula for the attached file. Data in cell C4 will remain fixed, however if I change the amount, then formula should update automatically. As I enter data in cells D4:AH4, I need a formula in cell AH4 so that as i enter data in D4:AH4 it should show stock remaining in cell AH4.
I have attached the file, so once you open it, you will have an idea of what I am trying to do!!
Bookmarks