Seems SUMIF function did not handle #REF! properly. Calculate to incorrect results

XMLWordPrintable

    • Type: Bug
    • Resolution: Fixed
    • Priority: Normal
    • 6.1.0
    • Affects Version/s: None
    • Component/s: Formula
    • None
    • None

      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

       

        1. KEIKAI_SUMIF_BUG.xlsx
          16 kB
          henrichen

            Assignee:
            jumperchen
            Reporter:
            henrichen
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: