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
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
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