incubator-ooo-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From NoOp <gl...@sbcglobal.net>
Subject Re: Question about New functions in AOO3.4
Date Fri, 11 May 2012 18:32:30 GMT
On 05/09/2012 07:31 PM, Hirono Moi wrote:
> Hi,
> 
> I use AOO3.4,
>     OpenOffice.org 3.4.0
>     AOO340m1(Build:9590) - Rev 1327774
> in English(EN-US) and JAPANESE.
> 
> I can not find New conditional functions :
>     COUNTIFS, SUMIFS, AVERAGEIF and AVERAGEIFS,
> those are writen in AOO3.4 Release Notes:
> https://cwiki.apache.org/confluence/display/OOOUSERS/AOO+3.4+Release+Notes.
> 
> I tried to use them with CALC, Insert -> Function.
> 
> But I can not find out each of COUNTIFS, SUMIFS, AVERAGEIF and AVERAGEIFS.

Looks like two bugs have been opened for those:
<https://issues.apache.org/ooo/buglist.cgi?quicksearch=COUNTIFS>
 <https://issues.apache.org/ooo/show_bug.cgi?id=119303>
[I think this one is yours]
 <https://issues.apache.org/ooo/show_bug.cgi?id=105140>
[This one lists the tracking bugs for each - comment #2]

> 
> Could anyone explain me how do I use those new functions
> in AOO3.4 ?

These might be of help:
<https://office.microsoft.com/en-us/excel-help/excel-functions-by-category-HP010079186.aspx?CTT=3>
For example:
<https://office.microsoft.com/en-us/excel-help/countifs-function-HA010047494.aspx>

> 
> 
> Thanks for your help in advance.
> 
> Hirono



---------------------------------------------------------------------
To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
For additional commands, e-mail: ooo-users-help@incubator.apache.org


Mime
View raw message