This formula, =SUM(SUMIFS(E4:E11,D4:D11,{“complete”,“pending”})) , works in Excel, adding all numbers in E that have either “complete” or “pending” in the corresponding cell in D. In Calc, the formula only adds numbers meeting the first condition, “complete”. If I swap the position of the conditions in the formula, it only adds “pending” numbers. What do I need to change to make it work in Calc? Thanks.

UPDATE:

Keme’s answer works! So the difference is that Calc needs to be told that the formula is an array, whereas Excel doesn’t. Editing the formula as he describes works to convert the formula. But if I were to type the formula as above and enter CTRL+SHIFT+ENTER (instead to just ENTER), the formula is entered as an array formula and the brackets are automatically added at each end. Thanks to all who provided guidance.