To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=66023 Issue #:|66023 Summary:|sumif function fails to filter properly if using a |field that has either ( or ) in it Component:|Spreadsheet Version:|OOo 2.0.2 Platform:|All URL:| OS/Version:|Windows 2000 Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P2 Subcomponent:|editing Assigned to:|spreadsheet Reported by:|rbanfield
------- Additional comments from [EMAIL PROTECTED] Thu Jun 1 23:13:39 -0700 2006 ------- SUMIF function fails to properly find fields that match criteria if the criteria contains either ( or ). Not all characters were tested. Repro Steps: - Set 'Criteria': In Cells A2:A6 String one String (two) String three) String (four String – five Data (Cells A2:B26) : IE: Test ID's Counts String one 1 String (two) 2 String three) 3 String (four 4 String one 1 String (two) 2 String three) 3 String (four 4 String one 1 String (two) 2 String three) 3 String (four 4 String one 1 String (two) 2 String three) 3 String (four 4 String – five 20 In Cells B2:B5 Enter formula (changing using A2->A6 respectively) : =SUMIF(A$10:A$25;A2;B$10:B$25) Results: Validity Values Totals Exected = 4* # String one 4 4 String (two) 0 8 String three) 0 12 String (four 0 16 String – five 20 20 formulas were entered into first field, and then dragged. Below is resultant formulas.: =SUMIF(A$10:A$26;A2;B$10:B$26) =SUMIF(A$10:A$26;A3;B$10:B$26) =SUMIF(A$10:A$26;A4;B$10:B$26) =SUMIF(A$10:A$26;A5;B$10:B$26) =SUMIF(A$10:A$26;A6;B$10:B$26) --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
