[Table of Contents] [docx version]
SpreadsheetML Reference Material - Table of Contents
SUMSQ ( argument-list )
Description: Adds the squares of arguments in argument-list.
Arguments:
|
Name |
Type |
Description |
|
argument-list |
logical, number, name, text, array, reference |
The arguments in argument-list designate the values whose squares are to be summed. Arguments that are numbers, logical values, or text representations of numbers shall be counted. If an argument is an array or reference, only numbers in that array or reference shall be counted. Empty cells, logical values, and text in the array or reference shall be ignored. |
Return Type and Value: number – The sum of the squares of its arguments.
[Example:
SUMSQ(2) results in 4
SUMSQ(2.5,-3.6)) results in 19.21
SUMSQ({2.5,-3.6)},2.4) results in 24.97
end example]