From the OpenOffice bug report (angeldeath82): With Microsoft Excel 2007 they added a function (SUMIFS) which functions as follows: SUMIFS(SumRange,SearchRange,Criteria). They added this to deal with unsorted values in SearchRange, as their implementation of SUMIF is based on SearchRange being sorted. OpenOffice bug report: http://openoffice.org/bugzilla/show_bug.cgi?id=95144 Calc/ODFF Implementation/Examine functions: http://wiki.services.openoffice.org/wiki/Calc/ODFF_Implementation/Examine_functions
[This is an automated message.] This bug was filed before the changes to Bugzilla on 2011-10-16. Thus it started right out as NEW without ever being explicitly confirmed. The bug is changed to state NEEDINFO for this reason. To move this bug from NEEDINFO back to NEW please check if the bug still persists with the 3.5.0 beta1 or beta2 prereleases. Details on how to test the 3.5.0 beta1 can be found at: http://wiki.documentfoundation.org/QA/BugHunting_Session_3.5.0.-1 more detail on this bulk operation: http://nabble.documentfoundation.org/RFC-Operation-Spamzilla-tp3607474p3607474.html
Apache OpenOffice 3.4 will have new Conditional Functions : "Support conditional functions COUNTIFS, SUMIFS, AVERAGEIF and AVERAGEIFS" https://cwiki.apache.org/OOOUSERS/aoo-34-release-notes.html These functions are defined in ODF1.2 : http://docs.oasis-open.org/office/v1.2/cs01/OpenDocument-v1.2-cs01-part2.html#__RefHeading__1018586_715980110 I think we need this enhancement.
AOO 3.4 does not have these functions. The pending CWS originating from OOo times was not integrated. The current situation with LibO is waiting for license clearance.
Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=816f65da41c8c30e5854e333a6498e58c64303aa resolved fdo#41214 crash due to offset error
(In reply to comment #4) bah, wrong bug number in commit, that's for bug 50221 instead.
starting on AVERAGEIF, other function are to follow.
Winfried, please don't, I explained on the mailing list that we should not duplicate this effort, there is a complete and ready solution in the OOo CWS waiting for integration.
(In reply to comment #7) > Winfried, please don't, I explained on the mailing list that we should not > duplicate this effort, there is a complete and ready solution in the OOo CWS > waiting for integration. Eike, I must have misunderstood you completely. I will stop my work on AVERAGEIF and put this bug back to NEW (and get back to you on dev-list)
So, we finally have these in :-) I pushed a series of commits to master and libreoffice-4-0 branches. These implement AVERAGEIF, SUMIFS, AVERAGEIFS and COUNTIFS.