https://bz.apache.org/bugzilla/show_bug.cgi?id=62271
Bug ID: 62271
Summary: Error in computing count of unique values using
SUMPRODUCT and COUNTIF
Product: POI
Version: 3.17-FINAL
Hardware: PC
OS: Linux
Status: NEW
Severity: major
Priority: P2
Component: XSSF
Assignee: [email protected]
Reporter: [email protected]
Target Milestone: ---
This is the formula that I use for computing count of unique values in a range
of cells:
SUMPRODUCT(1/COUNTIF(A5:A10,A5:A10&""))
Although this formula works fine in excel, error is thrown in POI with the
following description:
Invalid arg type
for SUMPRODUCT: (org.apache.poi.ss.formula.eval.ErrorEval)
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
