Hi :) Hopefully someone can post your wishlist items to the developers list. As a workaround the clumsy
If (Test1, (IF (Test2, (COUNT (??)), otherwise?), otherwise?) Obviously this is "sub-optimal" for what you need but it should work as long as you keep track of all the brackets and remember to close them appropriately. Good luck and regards from Tom :) ________________________________ From: "[email protected]" <[email protected]> To: [email protected] Sent: Tue, 1 March, 2011 15:39:25 Subject: [libreoffice-users] Features request Don't know if this is the right place to make a feature request, but... Calc could use the following additional mathematical functions. AVERAGEIF - averages the argument which meet the set of conditions AVERAGEIFS - averages the argument which meet the multiple set of conditions COUNTIFS - counts the argument which meet the multiple set of conditions SUMIFS - sums the argument which meet the multiple set of conditions Are there plans to introduce these? Are there any workarounds for not having these? Thanks, Paul -- Unsubscribe instructions: E-mail to [email protected] List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity *** -- Unsubscribe instructions: E-mail to [email protected] List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
