ce
ce copied to clipboard
COUNTIF doesn't work if criteria contains a digit
Try this:
=COUNTIF([A1:E1],"A")
it works, but this does not:
=COUNTIF([A1:E1],"A3")
I'm trying different combinations, it always fails if criteria contains a digit, wherever it's in the string. Any clue?