Hi Mihovil, On Saturday, 2013-07-20 22:26:31 +0200, Mihovil Stanic wrote:
> If I didn't understand something wrong, this is 100% incorrect. > Criteria is NOT range.It's criteria, condition(number, text, logical > value etc...), but not range. Range is defined 2 strings before > thatand that is range on which CRITERIA is applied. > > Please check this, and ifI didn't understood this incorrectly, that > description should be changed. You're right, criteria are not ranges but each is checked for a range given, i.e. in SUMIFS(sum_range,range1,criteria1) for each element in range1 that meets criteria1 the corresponding element of sum_range is summed. > Same goes also for AVERAGEIFS and COUNIFS function. Yes. I'll correct the strings for 4.2 > Also, where is SUMIFS, AVERAGEIFS and COUNTIFS help? > Couldn't find it. Seems there isn't any yet. Eike -- LibreOffice Calc developer. Number formatter stricken i18n transpositionizer. GPG key ID: 0x65632D3A - 2265 D7F3 A7B0 95CC 3918 630B 6A6C D5B7 6563 2D3A For key transition see http://erack.de/key-transition-2013-01-10.txt.asc Support the FSFE, care about Free Software! https://fsfe.org/support/?erack -- To unsubscribe e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/l10n/ All messages sent to this list will be publicly archived and cannot be deleted
