Issue 65866

Summary: COUNTIF, SUMIF don't handle array as range
Product: Calc Reporter: ooo
Component: codeAssignee: AOO issues mailing list <issues>
Status: ACCEPTED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues, kozodaevroman, kyoshida
Version: OOo 2.0.2   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: ENHANCEMENT Latest Confirmation in: ---
Developer Difficulty: ---

Description ooo 2006-05-29 23:09:00 UTC
The array formula {=COUNTIF(IF(A2:A3=1;B2:B3;C2:C3);2)} results in Err:504
(error in parameter list), because the internal array returned by IF() isn't
handled by COUNTIF(), the same for SUMIF().
Comment 1 ooo 2006-05-29 23:09:46 UTC
Accepted.
Comment 2 niklas.nebel 2006-05-30 09:40:19 UTC
See issue 10798.
Comment 3 ooo 2007-10-12 16:40:05 UTC
*** Issue 10798 has been marked as a duplicate of this issue. ***
Comment 4 Marcus 2017-05-20 11:11:10 UTC
Reset assigne to the default "issues@openoffice.apache.org".