Uploaded image for project: 'Keikai'
  1. Keikai
  2. KEIKAI-614

multiple SUMIF() with the same sum range takes longer calculation time


    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Normal Normal
    • 5.11.0
    • 5.10.0
    • None
    • Security Level: Jimmy

      Steps to Reproduce

      1. enter 1 in A1
      check au request timing > waiting for server response

      Current Result

      it takes over 1s

      Expected Result

      less than 500ms

      Debug Information

      • in Sumif. sumMatchingCells, keikai evaluates the sum range ($A$1:$A$2000) first. Since there are many SUMIF() in the sum range, so it recursively evaluates SUMIF() for hundreds of times. it takes time.
      • if we put the repeated formula SUMIF($B$1:$B$2000,">0",$A$1:$A$2000) into a separate cell and reference it, it will create a circular reference and can't produce a correct result because keikai doesn't support this.


        1. keikai-614.xlsx
          16 kB
        2. profile snapshot.png
          profile snapshot.png
          74 kB
        3. waiting.jpg
          12 kB

            DevChu DevChu
            hawk hawk
            0 Vote for this issue
            2 Start watching this issue