香港新浪網 MySinaBlog
« 上一篇 | 下一篇 »
Emily | 23rd Sep 2006, 08:47 AM | General | (2546 Reads)
SUMPRODUCT is one of the most versatile functions provided in Excel. In its most basic form, SUMPRODUCT multiplies corresponding members in given arrays, and returns the sum of those products. This page discusses the classic use of SUMPRODUCT, how creativity and inbuilt flexibility has enabled it to evolve into a far more useful function, and explains some of the techniques being deployed. Finally, some examples of SUMPRODUCT show its versatility.

http://www.xldynamic.com/source/xld.SUMPRODUCT.html