![]() In other words, our SUMPRODUCT formula performs the following mathematical operations: When all of the array elements are multiplied, the formula adds up the products and returns the sum.The formula takes the 1 st number in the 1 st array and multiplies it by the 1 st number in the 2 nd array, then takes the 2 nd number in the 1 st array and multiplies it by the 2 nd number in the 2 nd array, and so on.Here is what's going on under the hood in terms of math: ![]() The following screenshots shows it in action: In Microsoft Excel, you can get the result with a single SUMPRODUCT formula: If you were doing a school math test, you would multiply the quantity by price for each item, and then add up the subtotals. Supposing you have quantity in cells A2:A4, prices in cells B2:B4, and you wish to find out the total. To gain a general understanding of how the Excel SUMPRODUCT function works, consider the following example.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |