Excel Tips - Tip 25 (Using Sum Product Formulae)

Hello,

Hope my excel tips are helping you out.

Here is Today’s tip for you. Hope this help you.

If ever we want to get a sum of data with multiplying the two coloumns with a single formulae, then we can use the function of “SUMPRODUCT” . As the name justify it first multiply and then sum the data range.

What Does It Do ?

·         This function uses at least two columns of values.

·         The values in the first column are multiplied with the corresponding value in the second column.

·         The total of all the values is the result of the calculation.

How to use it ?

'=SUMPRODUCT(Range1, Range, Range2 through to Range n)

For example, please check the images.

Hope the Tip is found interesting to you and the same is clear.

Looking forward for a feedback.

If any of your friend is also interested for the said excel Tips , then asked them to fill the form by clicking on the below mentioned link:

https://docs.google.com/forms/d/12T8v5XY0XlF9IhuCZPQpydd8hjCtrW7hZs9_GiOffIw/alreadyresponded?c=0&w=1

If you have something that you want to share with the group, please write to excelms.tips@gmail.com

Thanks & Regards,

CA Mohit Bansal

Excel Enthusiast

+91-9045773456