Multiply 2 Columns in Excel Hindi

SUMPRODUCT formula This article describes the formula syntax and usage of the SUMPRODUCT formula in Microsoft Excel.

Description - Multiplies corresponding components in the given arrays, and returns the sum of those products.



Syntax of SUMPRODUCT formula



SUMPRODUCT(array1, [array2], [array3], ...)



The SUMPRODUCT formula syntax has the following arguments:



Array1     Required. The first array argument whose components you want to multiply and then add.



Array2, array3,...     Optional. Array arguments 2 to 255 whose components you want to multiply and then add.



Remarks

The array arguments must have the same dimensions. If they do not, SUMPRODUCT returns the #VALUE! error value.



SUMPRODUCT treats array entries that are not numeric as if they were zeros.



To watch more videos and download the files visit http://www.myelesson.org

To Buy The  Full Excel Course visit . http://www.myelesson.org/product    or call 9752003788

Connect with us on Facebook - https://www.facebook.com/excelmadeasy/

Connect with us on Twitter - https://twitter.com/Excelmadeasy