ce icon indicating copy to clipboard operation
ce copied to clipboard

COUNTIF doesn't work if criteria contains a digit

Open dgiglio opened this issue 1 year ago • 0 comments

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?

dgiglio avatar Jul 27 '23 15:07 dgiglio