调试经验——Excel函数Sumproduct函数的应用 (Use of SUMPRODUCT function in Excel)

最新推荐文章于 2024-02-20 15:48:57 发布

预见未来to50

最新推荐文章于 2024-02-20 15:48:57 发布

阅读量586

点赞数

分类专栏： Excel技巧及VBA编程（Excel_VBA）

本文链接：https://blog.csdn.net/hpdlzu80100/article/details/80896097

版权

404 篇文章 169 订阅

订阅专栏

今天发现Sumproduct函数挺有用，具有多条件统计、查询的功能，有必要好好学学！

-------------------------------------------------------------------------------------------------------------

The Excel Sumproduct function returns the sum of the products of the corresponding values in a set of supplied arrays.

The syntax of the function is:

SUMPRODUCT( array1, [array2], [array3], ... )

where the array arguments are one or more arrays of numeric values that you want to sum the products of.

Note that:

All of the supplied arrays must have the same dimensions;
If just one array is supplied, the function returns the sum of the values in that array.
Non-numeric values in the supplied arrays are treated as the value zero;
In current versions of Excel (Excel 2007 and later), you can provide up to 255 arrays of values to the Sumproduct function, but in Excel 2003, the function can only handle up to 30 arrays of values;
Arrays that are supplied directly to the Sumproduct function should be surrounded by curly braces, with values in the same row separated by a comma and each row separated by a semicolon. An example of a vertical array is shown in cells C3 and C4 of the 'Formulas' spreadsheet below.

关注

专栏目录