The usage scenario of this announcement is the sum of multiple columns of the SUMIFS function, which is equivalent to the following: =SUMIFS($C:$C,$B:$B,$A1)+SUMIFS($D:$D,$B:$B,$A1)+…. Obviously, the above formula is simpler. Using the binary tree recursion method, you only ne...