求助:怎样在ACCESS中实现"sumproduct"?

fatfish

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*C24) entered as an array.



Thanks in advance!!



Best Regards,

FF

宿命的风

can you speak chinese?

CHENZHIRONG

方法1。引用EXCEL的APPLICATION实例，然后就可以用EXCEL的函数了2。在ACCESS中写函数。

fatfish

恍然大悟。。 多谢！！