Definition:
SUM function is used to calculate a simple total for a range of cells.Some of the SUM functions are listed below.
- SUM(number1,number2,...)
- SUMIF(range, criteria,sum_range)
- SUMIFS(sum_range,criteria_range,criteria,...)
- SUMSQ(number1,number2,...)
- SUMPRODUCT(array1,array2,array3,...)
- SUMX2MY2(array_x,array_y)
- SUMX2PY2(array_x,array_y)
- SUMXMY2(array_x,array_y)
1. SUM(number1, number2,...):
Adds all the numbers in a range of cells.
Figure: SUM Function
2. SUMIF(Range, Criteria, Sum_Range):
Adds the cells specified by a given condition or criteria.
Figure: SUMIF Function
3. SUMIFS(sum_range,criteria_range,criteria,...):
Adds the cells specified by a given set of conditions or criteria.
Figure: SUMIFS Function
4. SUMSQ(number1,number2,...):
Returns the sum of the squares of the arguments. The arguments can be numbers, arrays, names, or references to cells that contain numbers.
Figure: SUMSQ Function
5. SUMPRODUCT(array1,array2,array3,...):
Returns the sum of the products of corresponding ranges or arrays.
Figure: SUMPRODUCT Function
6. SUMX2MY2(array_x,array_y):
Sums the differences between the squares of two corresponding ranges or arrays.
Figure: SUMX2MY2 Function
7. SUMX2PY2(array_x,array_y):
Returns the sum total of the sums of squares of numbers in two corresponding ranges or arrays.
Figure: SUMX2PY2 Function
8. SUMXMY2(array_x,array_y):
Sums the squares of the differences in two corresponding ranges or arrays.
Figure: SUMXMY2 Function
Notes:
