Sumproduct function in Excel

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.