Steps to Reproduce

Load the uploaded sample excel file KEIKAI_SUMIF_BUG.xlsx.

Value in Cell M77 should be calculated to zero

Current Result

Value in Cell M77 now is calculated to 15250(which is not correct)

Expected Result

Value in Cell M77 should be calculated to zero

Debug Information

• Tested on 6.1.0-jakarta.FL.202501091624-Eval and online Kekei demo. Both incorrect (calculated 15250).
• Should be an old issue (I guess it is because the #REF!)
• The formula in M77 is `=M123+SUMIF($K$1:$K$52,$G77,M$1:M$52)+SUMIF($L$1:$L$52,$G77,M$1:M$52)`
• I found 15250 == SUM(M$1:M$52) * 2

Workaround