Apache OpenOffice (AOO) Bugzilla – Issue 65866
COUNTIF, SUMIF don't handle array as range
Last modified: 2017-05-20 11:11:10 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().
Accepted.
See issue 10798.
*** Issue 10798 has been marked as a duplicate of this issue. ***
Reset assigne to the default "issues@openoffice.apache.org".