Issue 127939 - COUNTIFS syntax listed wrong
Summary: COUNTIFS syntax listed wrong
Status: CLOSED DUPLICATE of issue 105140
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: 4.1.5
Hardware: PC Windows 10
: P5 (lowest) Minor (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2018-11-17 21:44 UTC by livelongandprosper47
Modified: 2018-11-18 14:21 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description livelongandprosper47 2018-11-17 21:44:31 UTC 
While the COUNTIFS function is indeed present within Calc 4.1.5, the syntax listed under the function bar when filling in the COUNTIFS function is wrong.

The syntax is listed as: COUNTIFS(range 1, criteria 1; range 2, criteria 2; ...)
The syntax needed to make the function work however is: COUNTIFS(range 1; criteria 1; range 2; criteria 2; ...)

I could not find any documentation covering this within the help window.
Comment 1 oooforum (fr) 2018-11-18 13:22:18 UTC 
Already reported

*** This issue has been marked as a duplicate of issue 105140 ***