After all the operations are performed, the results are summed as usual. Use SUMPRODUCT as usual, but replace the commas separating the array arguments with the arithmetic operators you want (*, /, +, -). The first array argument whose components you want to multiply and then add.Īrray arguments 2 to 255 whose components you want to multiply and then add. The SUMPRODUCT function syntax has the following arguments: To use the default operation (multiplication): SUMPRODUCT matches all instances of Item Y/Size M and sums them, so for this example 21 plus 41 equals 62. In this example, we'll use SUMPRODUCT to return the total sales for a given item and size: The default operation is multiplication, but addition, subtraction, and division are also possible. The SUMPRODUCT function returns the sum of the products of corresponding ranges or arrays.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |