Bug 62271 - Error in computing count of unique values using SUMPRODUCT and COUNTIF
Summary: Error in computing count of unique values using SUMPRODUCT and COUNTIF
Status: NEW
Alias: None
Product: POI
Classification: Unclassified
Component: XSSF (show other bugs)
Version: 3.17-FINAL
Hardware: PC Linux
: P2 major (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2018-04-09 09:35 UTC by raghavi
Modified: 2018-04-10 09:53 UTC (History)
1 user (show)



Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description raghavi 2018-04-09 09:35:35 UTC
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)