EXCEL SUMPRODUCT
The SUMPRODUCT is used to perform operations on arrays and return the sum of the products of corresponding           elements from multiple arrays or ranges.
Syntax:Â
      =SUMPRODUCT(array1,[array2],[array3],….)
Arguments or Parameters
array1: first array to be multiply.
array2: second array to be multiply.
Objective: Multiply the Price with Quantity and find the Grand total in cell h3.
   Step 1:
Type = sign in cell H3.
Type SUMPRODUCT Function
   Step 2:
Select E3:E22 as the first array
Type “*”
Select F3:F22 as the second array
Close Bracket with “)”
Press Enter
Result: The SumProduct function has multiplied the Price by Quantity and given the GrandTotal in cell H3.
Â
