今天发现Sumproduct函数挺有用,具有多条件统计、查询的功能,有必要好好学学!
-------------------------------------------------------------------------------------------------------------
Function Description
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.