search

jspreadsheet / ce

Jspreadsheet is a lightweight vanilla javascript plugin to create amazing web-based interactive tables and spreadsheets compatible with other spreadsheet software.
https://bossanova.uk/jspreadsheet/v4
MIT License
6.66k stars 820 forks source link

COUNTIF doesn't work if criteria contains a digit #1635

Open dgiglio opened 11 months ago

dgiglio commented 11 months ago

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?