W
Werner Rohrmoser
Hi,
I have a found something strange, which I do not understand.
Formula in A1: =SUMIF(D13,C1,E1:E3)
value in C1: 02016521000513438888 formatted as text
values in D13 : 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
I have a found something strange, which I do not understand.
Formula in A1: =SUMIF(D13,C1,E1:E3)
value in C1: 02016521000513438888 formatted as text
values in D13 : 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