What is the Excel SUM Function? Excel SUM function is used to add all numbers stored in the function argument. The SUM function argument can be a number, logical values, range, cell, array or even an excel formula. SUM Syntax =SUM(number1, , …) number1 is mandatory …

What is SUMPRODUCT Function? The SUMPRODUCT function multiplies corresponding ranges or arrays and returns the sum of those products. SUMPRODUCT Syntax SUMPRODUCT(array1, , , ...) array1, required. The first data to be multiplied, then sum. , optional. The second data to be multiplied, then sum. Usage …

What is the DATEDIF function? The Excel DATEDIF function calculates the number of days, months or years between two dates. The Excel DATEDIF function is an undocumented function, even though in newer Excel versions you can find the DATEDIF function documentation in the Excel help menu. …

What is the Excel QUOTIENT Function? The QUOTIENT function returns an integer portion of the division. This function is useful if you don’t need the remainder of a division. QUOTIENT Syntax QUOTIENT(numerator, denominator) numerator, required, the number to be divided (the dividend) denominator, required, the number …

What is the MOD function? What does mod stand for in math? MOD stands for modulus, an operation to find the remaining number after a division operation. What is the MOD function in Excel? A function to calculate the remainder of the division. MOD Function Syntax …