No.Paula12140 wrote:There have been several issues with users attempting to use the CountIfs, SumIfs, and AverageIfs functionality from Excel 2007. Have equivalents been created for OO v 3.3 yet for any of the above?
To count with SUMPRODUCT: =SUMPRODUCT(1stCriteria;2ndCriteria;…)Paula12140 wrote:I've found some things about SumProduct being used for CountIfs and SumIfs. Does SumProduct successfully replace both of these functions in OpenOffice Calc?
Paula12140 wrote:Our office just switched from MS Excel 2007 to OpenOffice calc and writer. There have been several issues with users attempting to use the CountIfs, SumIfs, and AverageIfs functionality from Excel 2007. Have equivalents been created for OO v 3.3 yet for any of the above?
I've found some things about SumProduct being used for CountIfs and SumIfs. Does SumProduct successfully replace both of these functions in OpenOffice Calc?
Thanks a bunch.
acknak wrote:They're not the same functions. MS added the {COUNT,SUM,AVERAGE}IFS functions in Excel 2007 and they have not been implemented in Calc yet.
ODF Spreadsheet learns new Conditional Functions
Support conditional functions COUNTIFS, SUMIFS, AVERAGEIF and AVERAGEIFS
kingfisher wrote:BTW, an issue about the absence of the new functions in AOO 3.4 (to be) has been filed.
crusader wrote:... what is ">1" evaluating? ...
Thank you, Acknak: that is the answer I was looking for! I now understand how and why the formula works, allowing me to employee it effectively.acknak wrote:In the goofy world of spreadsheets, any text value is greater than any numeric value...
An enlightened mortal agrees...acknak wrote:The primary value of the new functions is just clarity, as far as I can see: they're easier to understand and to use. SUMPRODUCT is a "swiss army knife" well-known to spreadsheet wizards, but a rather impenetrable mystery to mere mortals.
Users browsing this forum: k9gardner and 39 guests