SUMPRODUCT() in Excel in Hindi
Multiplies corresponding components in the given arrays, and returns the sum of those products.
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.
You can also learn more Advance Excel Tips & Tricks.
Or Visit Us. Excel Training in Gurgaon, Mumbai, Delhi.