Microsoft Office Tutorials and References

In Depth Information

**APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE**

SUMPRODUCT(array1,array2,array3, ...) [Category: Math]

Multiplies corresponding components in the given arrays, and returns the sum of

those products. Guru Tip: SUMPRODUCT allowed you to do SUMIF, COUNTIF,

SUMIFS long before these functions existed. See numerous examples at the

beginning of this topic. To replace the SUMIFS in the image above, use the

SUMPRODUCT in the image below. Also see page 15

SUMSQ(number1,number2, ...) [Category: Math]

Returns the sum of the squares of the arguments.

SUMX2MY2(array_x,array_y) [Category: Math]

Returns the sum of the difference of squares of corresponding values in two

arrays.

SUMX2PY2(array_x,array_y) [Category: Math]

Returns the sum of the sum of squares of corresponding values in two arrays. The

sum of the sum of squares is a common term in many statistical calculations.

SUMXMY2(array_x,array_y) [Category: Math]

Returns the sum of squares of differences of corresponding values in two

arrays.

SYD(cost,salvage,life,per) [Category: Financial]

Returns the sum-of-years’ digits depreciation of an asset for a speciﬁ ed period.

Guru Tip: VDB is more ﬂ exible.

T(value) [Category: Text]

Returns the text referred to by value. Guru Tip: This is the corollary to the N

function. =T of text is text. =T of number is nothing. While people have found