In the given sets of arrays, multiply the corresponding elements between the arrays and return the sum of the products.
Syntax
SUMPRODUCT(array1, array2, array3, ...)
Array1, array2, array3, ... are 2 to 30 arrays, and their corresponding elements need to be multiplied and summed.
Description
■The array parameters must have the same dimensions, otherwise, the function SUMPRODUCT will return the error value #VALUE!.
■Function SUMPRODUCT converts non-numeric arrays Elements are treated as 0.
In life and work, we often use EXCEL tables to Help us calculate statistics, so how to quickly calculate the total sales volume of a certain product?
Here's a little trick to teach you how to quickly use the SUMPRODUCT function in WPS2019EXCEL to count total sales and total volume in one second.
Take this product sales form as an example.
■Place the cursor at (E3) and click Insert Function-Mathematics and Trigonometric Functions-SUMPRODUCT function.
There are two parameters in the pop-up dialog box.
"Array 1" and "Array 2" are the data you want to calculate, and you can add new arrays for calculation.
■Enter (C3) into "array 1", (D3) into "array 2", click OK to get the sales volume of a single region
Position the cursor to the lower right corner of cell (E3), pull down and copy the formula when it is in the shape of +, and the sales of all single regions will be calculated.
■Place the cursor at (G3), click to insert the SUMPRODUCT function, enter (D3:D14) in "Data 1", and click OK to get the total sales volume.
■Similarly, place the cursor at (G5), click to insert the SUMPRODUCT function, enter (C3:C14) in "Data 1", and enter (C3:C14) in "Data 2" enter
(D3:D14), click OK to get the total sales volume.
How about this, have you learned this quick and easy trick to calculate sales?
评论列表(196条)
测试