Created attachment 37689 [details] test case for reproduction I'm managing an XFFS workflow within which I have a formula cell with a SUMIFS nside a SUMPRODUCT. But its evaluation give a bad result: it is different from Excel of Office 365. The nested SUMIFS uses ranges as criteria. For example: SUMPRODUCT(SUMIFS(B1:B3, C1:C3, D1:D3)) The evaluation is done via FormulaEvaluator.evaluateAll(). I'm providing a test case for more details.
Created attachment 37690 [details] expected output if workbook written on file system
Is there a difference to this bug-report to bug #65058?
Yes. The bug #65058 is about an error occuring with some parameter management. It seems that this happens when a criteria range is starting at a different column *and* row from the initial formula. This bug is more about the evaluation providing wrong results when we avoid the above parameters. Having done some more analysis, I have noticed that SUMIFS evaluations are not providing an array result when some criteria are multi-valued.
Created attachment 37715 [details] simplified test case for bug reproduction New test case to focus on pure formula evaluation.