SUMSQ takes multipleargumentsin the formnumber1,number2,number3, etc.

up to 255 total.

Arguments can be a hardcoded constant, a cell reference, or arange.

Excel SUMSQ function

All numbers in the arguments provided are squared then summed.

The SUMSQ function automatically ignores empty cells and text values.

Values can be supplied as constants, cell references, or ranges.

Excel SUMX2MY2 function

Values can be supplied as constants, cell references, or ranges.

Values can be supplied as constants, cell references, or ranges.

Values can be supplied as constants, cell references, or ranges.

Excel SUMX2PY2 function

Excel SUMXMY2 function