Thank you for your response. It helped me, and it has been working...
Regards -------------------------------------------------------------------------------- Pavel Cuc 1C Pro s.r.o. / Radcina 18 / 16100 Praha 6 tel.: +420 602 273 852 / skype: pavelcuc e-mail: [email protected] / www.1cpro.cz -------------------------------------------------------------------------------- From: Regina Henschel Sent: Monday, June 22, 2015 5:17 PM To: [email protected] Cc: [email protected] Subject: Re: SUMIFS doesn't works in OO 4.1.1. Hi Pavel, 1C Pro - Pavel Cuc schrieb: > Hello. > > I guess, that “SUMIFS” function doesn’t work in Open Office. > > I am using OO 4.1.1. > > I wrote a simple function, as it is described in the function wizard, but > with no success. > > =SUMIFS(SeznamZakazek.F6:F253;SeznamZakazek.C6:C253,B9;SeznamZakazek.D6:D253,B5) > > The problem is with the comma “,” character as the separator between the area > and criteria. > > If the comma “,” character is in the function, the “Error:501” message is > appeared. > > If the semicolon “;” character is in the function instead of the comma, no > error is appeared, but the result is wrong, because the result is always zero > “0”. > In AOO the delimiter between the function parameters is always a semicolon. So this would be right: =SUMIFS(SeznamZakazek.F6:F253;SeznamZakazek.C6:C253;B9;SeznamZakazek.D6:D253;B5) Are you sure, that any row meets the criteria? Keep in mind, that SUMIFS performs an AND on the conditions. Kind regards Regina
