What does the SUMPRODUCT function do in Excel?
-
A
Multiplies corresponding elements in arrays and returns the sum of those products
-
B
Adds all products in a product catalog
-
C
Calculates the sum and product separately
-
D
Multiplies all values in a single range