Hello,

I am creating an Excel spreadsheet in Google Sheets.

I have one column that has numbers in it:

i.e.

1
2
1
5

The numbers represent fixes. When a fix is made, the number will receive a strikethrough in the cell.

I want the header for that column to read "x of 9 fixes remaining" where "x" automatically counts down when a strike through is applied in the cell. (i.e. When the first cell receives a strikethrough, it should say "8 of 9 fixes remaining".)

Please let me know if this is possible.

Thanks!