|According to this thread, which admittedly is about a year old, there is (was?) no SUMIFS in OpenOffice. The suggestion is to go back to the method for "sumifs" before SUMIFS was available in Excel: use SUMPRODUCT.|
I don't use OpenOffice, so I don't know if anything has changed since that thread was opened.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.