On Sat, 2012-05-12 at 15:26 +0200, Regina Henschel wrote: > Hi Ricardo, > > RGB ES schrieb: > > The release notes mention "ODF Spreadsheet supports new Conditional > > Functions": COUNTIFS, SUMIFS, AVERAGEIF and AVERAGEIF. > > > > As far as I understand it, the support was only implemented on ODF, > > not on Calc, but some users on the forums are confused about those > > functions not working on AOO 3.4. Which is the right answer to their > > questions? > > I think, that the release note is wrong for this functions. According to > https://issues.apache.org/ooo/show_bug.cgi?id=90269 the implementation > was in cws calcishmakkica. But I do not see, that this cws had been > integrated. > > Eike Rathke has mentored Marina (makkica), so he should now the state of > the work. Perhaps ask him? > > The cws itself is in https://bitbucket.org/mst/ooo340 > > Kind regards Hi Regina
I think you are correct - I've been fiddling since reading Ricardo's email. Went to the ODF 1.2 document: http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#COUNTIFS and constructed an example spreadsheet - I don't think countfs is being recognized as a function at all. Countif for a single range works fine, but swtich to countfs and add a second range, same criteria, and all it gives is #Name error. //drew
