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”. I didn’t find any other character working... it is very annoying, because it is very useful function. 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 --------------------------------------------------------------------------------
