SUMPRODUCT is one of the most powerful Excel functions. It can sum and multiply the ranges or arrays.
In simple words, it first multiplies the corresponding cells from ranges and then sum up all the values.
SUMPRODUCT(array1, [array2], [array3], ...)
In the below example, we have used SUMPRODUCT to multiple and sum up the values from column D and column F.
First, it has multiplied the values from column D with column F and then sums up the values.