I am currently setting up a very basic spreadsheet to keep track of how many times an item of uniform has been washed. The keeping total throughout the year and bringing previous years totals through is straightforward however the problem arises when I want to get the count to return to zero when the item is replaced.
When the item is washed a 1 is entered in the data base and this is added to the total column. If the item then needs to be replaced a code of either R1, R2, R3, R4 or R5 is entered into the data base. I need the total count column to reset to zero if any of the above codes appear in the data! It sounds relatively straightforward to me (as a relative technophobe) but I am completely at a loss if it can be done. Any ides would be appreciated.