이 함수는 Google Sheets에서도 Excel과 동일하게 작동합니다 — 구문과 인수가 같습니다.
SUMSQ(number1, [number2], ...)The SUMSQ function calculates the sum of the squares of the provided numbers, arrays, or cell references. It is commonly used in statistical calculations, such as determining variance or standard deviation.
=SUMSQ(3, 4)결과: 25
Calculates 3 squared (9) plus 4 squared (16), which equals 25.
Yes, SUMSQ ignores text, logical values, or empty cells within a range.