Excel expression "sumproduct" in Access
 

Hi all,

I'm now building an Access databse and analysis market report.
Does anyone know that how to realize the Excel expression "sumproduct"
in Access?

Sumproduct: Multiplies corresponding components in the given arrays
and returns the sum of those products.
SUMPRODUCT(array1,array2,array3, ...)

It returns similiar result as the formula SUM(A2:B4*C2:D4) entered a
an array.

Thanks in advance!! :)

Best Regards,
F

--
Message posted from http://www.ExcelForum.com