Excel Function : DPRODUCT
Multiplies the values in a particular field of records that match the criteria in a database
Microsoft Excel Reference Page
Syntax and Description of the DPRODUCT Excel Function
The Excel DPRODUCT function returns the dot product of two vectors. The syntax of the function is: DPRODUCT(array1, array2) where array1 and array2 are the vectors for which you want to calculate the dot product.
About DPRODUCT Excel Function
DPRODUCT is a function in Microsoft Excel that returns the product of values in a column or row in a table. The product is the result of multiplying all the numbers in a column or row.