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: [email protected] For additional commands, e-mail: [email protected]
