SUMIFS on criteria range with leading zero in text
A B
1 ‘006 1
2 ’06 2
3 ‘6 4
4
5 Total =SUMIFS(B1:B3, A1:A3, “06”)
The formula result of =SUMIFS(B1:B3, A1:A3, “06”) is 7, while it should be 2…
The same problem with COUNTSIFS.
A possible tweak to the wrong result, is to add a letter in front of the leading zero texts (eg. “V006”, “V06” and “V6” in the range A1:A3).
A B1 ‘006 12 ’06 23 ‘6 445 Total =SUMIFS(B1:B3, A1:A3, “06”) The formula result of =SUMIFS(B1:B3, A1:A3, “06”) is 7, while it should be 2… The same problem with COUNTSIFS. A possible tweak to the wrong result, is to add a letter in front of the leading zero texts (eg. “V006”, “V06” and “V6” in the range A1:A3). Read More