Resetting a count to zero when entering a specified item in a data range

[Kerr01]

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.

[alansidman]

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. 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 demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[Kerr01]

thanks I have inserted a text box explaining what I need - if it isn't possible could you suggest any other way to achieve the desired results?