there seems to be a lot off discussion about the sumifs function.
first:
there is a difference between the sumif and the sumifs function.
the sumif function sums a column depending on the value if one other coulmn.
the sumifs function sums a column depending on the values if many other columns.
so with the sumif function one can say:
count the value of column a if the value if of column b is 'yes'.
with the sumifs:
count the value of column a if the value if of column b is 'yes' and the value of column c is 1 and the value of column d is march.
second:
is this implemented or not.
when i open this document:
www.openoffice.org/sc/testdocs/formula_ ... ff8_12.xlson tab function in section 4.6 function supported in oox you will see the sumifs function.
when i open it in OO 3.4 it will give an error. (#MACRO?)
so to me it seems that the SUMIFS functino is an imported function (which is implemented by microsoft in 2007) and is not working in OO.