On 03/01/2011 07:39 AM, pkaplan1@comcast.net wrote:
Don't know if this is the right place to make a feature request, but... Calc could use the following additional mathematical functions.
Open Help & select the Index tab:
AVERAGEIF - averages the argument which meet the set of conditions AVERAGEIFS - averages the argument which meet the multiple set of conditions
Maybe DAVERAGE? <http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Calc:_Database_functions> <http://www.oooforum.org/forum/viewtopic.phtml?t=11333> <http://www.oooforum.org/forum/viewtopic.phtml?t=85448> Also see: http://openoffice.org/bugzilla/show_bug.cgi?id=101466 [ODFF: implement AVERAGEIF and AVERAGEIFS] [Status: VERIFIED FIXED] http://openoffice.org/bugzilla/show_bug.cgi?id=117000 [Implement Excel import/export for AVERAGEIF, AVERAGEIFS, SUMIFS and COUNTIFS] I've not looked to see if an related LO bug has been filed. You might check & if not, file a bug report and reference those.
COUNTIFS - counts the argument which meet the multiple set of conditions
Included. "COUNTIF Returns the number of cells that meet with certain criteria within a cell range." <http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Calc:_COUNTIF_function>
SUMIFS - sums the argument which meet the multiple set of conditions
Included. "SUMIF Adds the cells specified by a given criteria. This function is used to browse a range when you search for a certain value." <http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Calc:_SUMIF_function> Also see: <http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Calc:_Functions_listed_by_category> http://www.libreoffice.org/get-help/documentation/ -- Unsubscribe instructions: E-mail to users+help@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***