Sumproduct Microsoft Excel. Charley has worked with spreadsheets in business since 1979 and has written books on spreadsheet use for mcgraw hill and microsoft press. The sumproduct function works with arrays but it doesn t require the normal array syntax ctrl shift enter to enter.
Sumproduct b2 b11 c2 c11 and microsoft excel will implement it as. If you re impatient you can skip the tutorial and download the sample excel file from the end of this post. To create the formula type sumproduct b3 b6 c3 c6 and press enter.
Similarly a subtraction sumproduct can be used as.
The purpose of the sumproduct function is to multiply then sum arrays. Here the formula is. To create the formula type sumproduct b3 b6 c3 c6 and press enter. Sumproduct b2 b11 c2 c11 this will be implemented internally as.
