In previous post, we learnt about Sum, SumIf and SumIfs function in Excel. In this post, we shall learn about SUMPRODUCT, SUMSQ function in MS Excel.
SUMPRODUCT function in Excel is used to sum the products (multiplication) of corresponding ranges.
In below example, we want to get the total amount spent, so in D6 cell we have written '=SUMPRODUCT(C3:C5,D3:D5)' so it does following
and here is the result.
The benefit we got is that we do not need to have a separate column (We have kept E column just for clarity purpose) to multiple Rate and Qty and then add it.
Thanks for reading, if you liked it do share to your friends and colleagues.
SUMSQ function is used to sum the square of the given range. In below example, we have written '=SUMSQ(D3:D5)' formula in D6 cell that squares the value of D3 to D5 cells and add.
Here is the result.
The E column is just for reference purpose.
Lik e to SUMSQ we have
As there are not very frequently used so no explanations are provided in this post.
Thanks for reading, if you liked this do share to your friends and colleagues.Views: 3799 | Post Order: 20