Reply To: Explanation of SUM PRODUCT – An important formula in excel

Actuary Forums › Forums › Learnings › Daily Dose › Explanation of SUM PRODUCT – An important formula in excel › Reply To: Explanation of SUM PRODUCT – An important formula in excel

January 30, 2019 at 7:00 pm #24444
Mayank Goyal
Keymaster

    shreyanshh wrote:

    This function is used to find the sum of product of corresponding elements of two or more column.

    For example – in case, to find the mean of the data set ‘X’, with frequency ‘F’, the function sum product can be used to find the sum of product of ‘F’ and ‘X’ i.e. Sigma F X.

    Step 1-go to the cell where you want to find the sum product and type ‘=sumproduct’.

    Step 2- the arguments of this function are [array 1,array 2,array 3….]. Select the arrays/column one by one whose sum product we want to find.

    Suppose, in the above example to find the sum product of ‘F X’, we will select the data set of F and X.

    Step 3- press enter and we will get the sum product.

    NOTE – the number of data in each array should be same, otherwise this function will not work.

    Sent from my S6s using Actuarial Info mobile app

    The use of the functios is maximum to get weighted average and it just require two rows to do so, I mean just the data set, you don’t require any manual calculation for multiplication! It is a nice function ;)

    Thanks for sharing [emoji4]

    Sent from my LLD-AL10 using Actuarial Info mobile app