Función de Google Sheets

SUMSQ

Returns the sum of the squares of the arguments.

Generar una fórmula con IA La misma función en Excel

Esta función funciona igual en Google Sheets que en Excel: misma sintaxis y mismos argumentos.

Sintaxis

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.

Argumentos

number1obligatorioThe first number, cell reference, or range for which you want the sum of squares.
number2opcionalAdditional numbers, cell references, or ranges, up to a maximum of 255 arguments.

Ejemplos

=SUMSQ(3, 4)

Resultado: 25

Calculates 3 squared (9) plus 4 squared (16), which equals 25.

Preguntas frecuentes

Does SUMSQ ignore text in ranges?

Yes, SUMSQ ignores text, logical values, or empty cells within a range.

Funciones relacionadas

SUM SUMPRODUCT