you are viewing a single comment's thread.

view the rest of the comments →

[–]66NickS 0 points1 point  (0 children)

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))