Issue 65866 - COUNTIF, SUMIF don't handle array as range
Summary: COUNTIF, SUMIF don't handle array as range
Status: ACCEPTED
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 2.0.2
Hardware: All All
: P3 Trivial with 5 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
: 10798 (view as issue list)
Depends on:
Blocks:
 
Reported: 2006-05-29 23:09 UTC by ooo
Modified: 2017-05-20 11:11 UTC (History)
3 users (show)

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


Attachments

Note You need to log in before you can comment on or make changes to this issue.
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".