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