Progress® Kendo UI® for jQuery Feedback Portal
Back to Feed
Request a Feature Report a Bug
Unplanned
Last Updated: 17 Jun 2026 12:54 by Marius
Marius
Created on: 17 Jun 2026 12:54
Category: Spreadsheet
Type: Bug Report
1
COUNTIF is not consistent with Excel

Bug report

Reproduction of the problem

Run this dojo - https://dojo.telerik.com/MkKhDjxX

The results are different when using the same values in Excel.

Current behavior

Result comparison for cells with numeric values

  COUNTIF(B5:B9,”<> “) COUNTIF(B5:B9,”<>11”) COUNTIF(B5:B9,”*” COUNTIF(B5:B9,”?3”)
Kendo 4 3 4 1
Excel 5 4 0 0

Result comparison for cells with text values

  COUNTIF(B12:B16,”<>11”) COUNTIF(B12:B16,”<>???00”)
Kendo 3 4
Excel 5 1

TicketID:

1715542

Environment

  • Kendo/Telerik version: 2026.2.520
0 comments
Create an account Log In
View
Type
Status
Category