Hi

I need to be able to make a selection from a drop down box and when a specific selection is made I.E. "Yes" it will subtract the number from the total amount remaining.

I need to be able to also complete this over multiple cells

I have attached a sample spreadsheet

You will see there are two items with High Priority on them and there is a '2' in the total column above

When yes is selected as complete I need it to remove 1 unit from the total numberFire Risk Assessment - Template 04-01-2024.xlsx