Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF, wrong result, strange behaviour
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Shortcut key strange behaviour | Excel Worksheet Functions | |||
Shortcut key strange behaviour | Excel Worksheet Functions | |||
Strange if(***) behaviour? | Excel Discussion (Misc queries) | |||
sumif wrong result | Excel Worksheet Functions | |||
Strange behaviour | Excel Worksheet Functions |