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? Regards Ricardo