In a spreadsheet (Version: 5.1.6.2) I want to count how often a cell contains the text “Done” in some range. I have tried the following expression:
=countif(J4:J30;“Done”)
but I only get an error popup
Invalid Value
What am I doing wrong?
I know why I have this problem. I have marked the cells with “Data → Validity”, and that formula was, no surpise, not in the list of allowed values.
The formula works as expected…