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]
