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
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
