Returns the sum of the squares of the arguments.
Hàm này hoạt động trong Google Sheets giống như trong Excel — cùng cú pháp và đối số.
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)Kết quả: 25
Calculates 3 squared (9) plus 4 squared (16), which equals 25.
Yes, SUMSQ ignores text, logical values, or empty cells within a range.