• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Recurring order total count monitor


I am trying to set up a spread sheet that will monitor the total numbers of bottles of gas that we have available in the plant room. Each time the gas runs out we have to request a change over by estates who will change over two bottles. I would like to be able to monitor the total number of gas bottles available based on how many have been most recently ordered minus any change over requests but also that a total given by estates would be the master figure usurping the calculations.

I am struggling to build the formula to calculate this. Any ideas?