https://issues.apache.org/bugzilla/show_bug.cgi?id=52462

--- Comment #5 from Yegor Kozlov <[email protected]> 2012-01-14 15:21:33 UTC ---
Here is initial implementation of SUMIFS. 

I think I covered most of it. The test case mimics the first example from
http://office.microsoft.com/en-us/excel-help/sumifs-function-HA010047504.aspx.
Please add Example 2 - Example 5, I added placeholders in TestSumifs.java

A tricky thing is to verify the behavior of SUMIFS against invalid or wrong
arguments. Please carefully read the spec and verify that the implementation
handles all cases (wrong type of arguments, ranges have different dimensions,
etc.). 

Feel free to edit the code if you find any bugs. 

P.S. It would be great if you follow the pattern and add support for other *IFS
functions from the AnalysisToolpack: AVERAGEIFS and COUNTIFS, they should be
pretty much similar to SUMIFS.

Regards,
Yegor

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- 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]

Reply via email to