You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2016/08/28 13:47:31 UTC

[Issue 127093] New: Bracketing error using sumifs

https://bz.apache.org/ooo/show_bug.cgi?id=127093

          Issue ID: 127093
        Issue Type: DEFECT
           Summary: Bracketing error using sumifs
           Product: Calc
           Version: 4.1.2
          Hardware: PC
                OS: Windows 7
            Status: UNCONFIRMED
          Severity: Normal
          Priority: P5 (lowest)
         Component: code
          Assignee: issues@openoffice.apache.org
          Reporter: james.godeaux@hotmail.com

Err:508 (error in bracketing) received when creating sumifs formula (equation).

2    salary
3    direct
7    salary
8    direct
9    salary
29    direct

=SUMIFS(a1:a6;b1:b6,"salary")

-- 
You are receiving this mail because:
You are the assignee for the issue.

[Issue 127093] Bracketing error using sumifs

Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127093

Marcus <ma...@apache.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|RESOLVED                    |CLOSED

-- 
You are receiving this mail because:
You are the assignee for the issue.

[Issue 127093] Bracketing error using sumifs

Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127093

Marcus <ma...@apache.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
         Resolution|---                         |NOT_AN_ISSUE

--- Comment #1 from Marcus <ma...@apache.org> ---
Have you seen the comma inside the parameter list? It has to be a semicolon
like the first one. Then it works for me.

-- 
You are receiving this mail because:
You are the assignee for the issue.