Google Sheets: function for counting down based on strike through

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!

My first sentence was not worded correctly. I will be using Google Sheets to host the spreadsheet.

Google Sheets has a free template called the "To Do" list.

It uses the formula below to change the value of "x" in (x/3 completed) when a row receives a strike through:

=CONCATENATE(COUNTIF($A$4:$A$51,TRUE), "/", COUNTA($C$4:$C$51), " completed ")

i.e. When a row receives a strike through, x turns into 1/3 completed.

I need to create a similar formula where it counts down based on the value in the cell.

Originally Posted by JeteMc

Perhaps the following will work:

Formula:

=CONCATENATE(COUNTA($C$4:$C$51)-COUNTIF($A$4:$A$51,TRUE), "/", COUNTA($C$4:$C$51), "  fixes remaining ")

Hope that this is helpful.

Thank you! This works if each cell only contains one fix. However each cell can have any number in it.