Date: prev next · Thread: first prev next last
2011 Archives by date, by thread · List index


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 ***

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.