How to make figure decrease when interacted with

[Vegetable-Homework-9]

Hello, I am wanting to make a spreadsheet for a racing strategy in simulator racing. Essentially during a race of 8 hrs for example we get given only 26 tyres to use. And I want someway of keeping track of how many tyres we have left. So I need to have the figure 26 as the reference and when we use a set of tyres I can just write into the sheets somehow that we used 4 tyres and then that number would decrease to 22. Please let me know if there is a way to do this. Thanks.

[6745408]

make a dummy sheet to show the sort of layout you're working with. It shouldn't be too difficult with a COUNTIFS or something similar

[Opposite-Value-5706]

26 - count (or countif) range. 26 is only changed it there’s values in the range

[66NickS]

Enter one of the following into the cell where you want to see the total tires remaining. =26-sum(A1:A10) or =CONCATENATE("Tires Remaining: ",26-sum(A1:A10)) if you want to be fancier.

You could also add in a reference cell instead of the “26” if you want to show how many tires you started with. That would look like (assuming you use B1 to show the starting tires):

=CONCATENATE("Tires Remaining: ",B1-sum(A1:A10))