Created attachment 106168 [details]
Screenshot of sumif() bug ignore "condition with (parenthesis)"
SUMIF() function ignores string with parenthesis as criteria.
Step to reproduce:
1. Create a table.
2. Put some name for condition. End each name with parenthesis.
3. Entry sumif() function at other cell to calculate.
Sampel screenshot will help you to reproduce the bug.
I can confirm that behavior since LO 18.104.22.168 to 22.214.171.124, also with AOO 4.1.1 under Ubuntu 12.04 x86. Seems inherited from OOO.
But according to m.a.riosv's comment in Bug 77343, disabling "Enable regular expressions in formulas" solves the issue. And I can confirm that.
Don't know if it's a bug or not, let someone decide.
*) Reset importance to normal, not qualified as a critical bug I think
Your question is answer in ask:
This is not a bug, please if you are not agree reopen it.