Office中国论坛/Access中国论坛

标题: 求助:怎样在ACCESS中实现"sumproduct"? [打印本页]

作者: fatfish 时间: 2004-6-25 06:26
标题: 求助:怎样在ACCESS中实现"sumproduct"?
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

4) entered as an array.

Thanks in advance!!

Best Regards,

FF

作者: 宿命的风 时间: 2004-6-25 16:24
can you speak chinese?

作者: CHENZHIRONG 时间: 2004-6-25 17:27
方法1。引用EXCEL的APPLICATION实例，然后就可以用EXCEL的函数了2。在ACCESS中写函数。

作者: fatfish 时间: 2004-6-26 03:57
恍然大悟。。多谢！！

欢迎光临 Office中国论坛/Access中国论坛 (http://www.office-cn.net/)