SUMIF, wrong result, strange behaviour
The problem is C1 is a string so excel is comparing the 1st character of the
strings. You can use VALUE to convert the string to a number.
"Werner Rohrmoser" wrote:
Hi,
I have a found something strange, which I do not understand.
Formula in A1: =SUMIF(D1:D3,C1,E1:E3)
value in C1: 02016521000513438888 formatted as text
values in D1:D3 : 0086WX6272000039947, 02016521000513439916,
02026821000513439916
values in E1:E3 : 130
2,214 1,675
Result of SUMIF should be 0, but I get 2,214.
This is something I do not understand.
BTW, you can change the last 4 digits of C1 to whatever you like,
you'll always get 2,214.
Any help is really appreciated.
Thanks.
Werner
|