Re: [libreoffice-l10n] SUMIFS function

I opened a bug some time ago.

https://bugs.freedesktop.org/show_bug.cgi?id=67810

Best regards,
Mihovil

Dana 15.8.2013. 18:50, Eike Rathke je napisao:
> 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


--
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