1. enter 1 in A1
check au request timing > waiting for server response
it takes over 1s
less than 500ms
- 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.