You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@openoffice.apache.org by Hirono Moi <hm...@ashisuto.co.jp> on 2012/05/10 04:31:30 UTC

Question about New functions in AOO3.4

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.

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


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

Re: Question about New functions in AOO3.4

Posted by NoOp <gl...@sbcglobal.net>.
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