I am using desktop Excel on Windows.
I have a single spreadsheet. In one cell, I have written a formula =countif(a1:a10, "*1")
. I get a correct value.
My question is, why have I lost the function and get only the value after I save and reopen the spreadsheet?