If the first parameter of sum formula and AVERAGE formula is bracketed, and multiple cell references separated by commas are used in the middle, one of which is not a numerical value, the formula calculation error occurs.
However, count is calculated normally. In addition, in version 20.1, sum and AVERAGE formulas can also be calculated normally.
image.png (22.3 KB)
image.png (22.0 KB)
there are codes and excel file.
EPPR-58764.zip (8.5 KB)