https://bz.apache.org/ooo/show_bug.cgi?id=127720
Issue ID: 127720 Issue Type: DEFECT Summary: DSUM function : character string as selection criteria not correctly handled (eg "EM" counted as "M") Product: Calc Version: 4.1.5 Hardware: PC OS: Windows 10 Status: UNCONFIRMED Severity: Normal Priority: P5 (lowest) Component: programming Assignee: issues@openoffice.apache.org Reporter: richard.watre...@free.fr Target Milestone: --- I want to signal a bug in OpenOffice Calc v4.1.5 (running on Windows 10) related to the DSUM function : A B C 1 Debits Type 2 100 M 3 200 EM 4 300 M 5 400 EM 6 150 D 7 260 D 8 Type 9 1000 M With A9 : DSUM(A1:A7;"Debits";B8:B9) : The formula gives 1000 instead of 800 (sum of « M » lines) ! The « EM » lines are also faulty selected (because « M » string is included in « EM » ?). So, M + EM lines give 1000, while M lines should only give 400 … I know that a correct result can be obtained with function SUM, like in A9 : SUM( (C2 :C7 = B9) * A2:A7 ) entered by pressing Ctrl-Shift-Enter But I have a large set of data files coded with the DSUM … -- You are receiving this mail because: You are the assignee for the issue.