for two sets of numbers, arrayX and arrayY, paired up one-to-one. The result is part of many statistical computations.
Description Computes
for two sets of numbers, arrayX and arrayY, paired up one-to-one. The result is part of many statistical computations.
Syntax SUMX2MY2(array1, array2)
| Argument | Description |
|---|---|
| arrayX and arrayY | Two range references or an array constants containing numeric values. Text, logical values, and empty cells referenced by this function are ignored, along with the number they are paired up with. That is, when a number from arrayX is paired up with text from arrayY, the entire pair is ignored.ArrayX and arrayY must contain the same potential number of values. |
Remarks This function pairs up the numbers in the two ranges by moving left-to-right through each sequential row.
Examples The examples are based on the following worksheet.
This function returns 285:
SUMX2PY2(A1:A5, B1:B5)
This function returns 256:
SUMX2PY2(A1:A3, B2:D2)
