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

On 03/01/2011 07:39 AM, 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 

Also see:
[Status:         VERIFIED FIXED]
[Implement Excel import/export for AVERAGEIF, AVERAGEIFS, SUMIFS and

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 

Returns the number of cells that meet with certain criteria within a
cell range."

SUMIFS - sums the argument which meet the multiple set of conditions 

Adds the cells specified by a given criteria. This function is used to
browse a range when you search for a certain value."

Also see:

Unsubscribe instructions: E-mail to
List archive:
*** All posts to this list are publicly archived for eternity ***


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.