Re: [libreoffice-l10n] SUMIFS function

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: l10n+unsubscribe@global.libreoffice.org
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