
Excel: Functions
MATHEMATICAL FUNCTION 1. SUM: Sum function is used to calculate a simple total for a range of numeric cells. SYNTAX: =SUM (number1, [number2], …) EXAMPLE: Add numbers stored in cell from cell numbers D1 to D4. 2. SUM PRODUCT: Returns the sum of the products of corresponding ranges of array SYNTAX: =sum product (array1, array2, [array3],…)…