SUMSQ 回傳多個數值、陣列或參考的平方和,語法 SUMSQ(number1, [number2], ...),最多 30 個參數。例:=SUMSQ(3,4) → 25(9+16),=SUMSQ(3,4,1) → 26(9+16+1)。避免手寫 =A1^2+B1^2+...,簡潔高效。
SUMSQ
SUMSQ(number1, [number2], ...)
=SUMSQ(3,4)
=SUMSQ(3,4,1)
=A1^2+B1^2+...