SUMIF and SUMIFS - Criteria Comparison Bug

Here’s an interesting one. The bug in SUMIF and SUMIFS is occurring when the criteria range has a number following a space. It isn’t recognizing that “Cat 9” = “Cat 9”

A1 = “Cat9” B1 = 5
A2 = “Cat” B2 = 50
A3 = “Cat 9” B3 = 500
A4 = “Cat 9 Lives” B4 = 5000

C1=SUMIF($A$1:$A$4,A1,$B$1:$B$4), and copy that down.
C1 should be 5, C2 should be 50, C3 should be 500, C4 should be 5000

However, C3 is returning 0.

This is valid issue wherein certain pattern String literals are incorrectly parsed as Dates. Tracking this as #-001584.

This Issue #001584 has been fixed with the latest upgrade.

3 Likes