WEMBA Excel Review

SUMPRODUCT function. Takes as inputs two separate ranges (i.e., the 1st number of the 1st range with the 1st number of the 2nd range, and so on), and then adds up all these individual products. =SUMPRODUCT(1st range, 2nd range) Warning: The ranges must match in size and shape. Absolute and relative referencing works as usual. Example ................
................