excel SUMPRODUCT function

Help us to keep this website almost Ad Free! It takes only 10 seconds of your time:
> Step 1: Go view our video on YouTube: EF Core Bulk Insert
> Step 2: And Like the video. BONUS: You can also share it!

Introduction

The SUMPRODUCT function multiplies corresponding components in the given arrays, and returns the sum of those products

Syntax

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

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.


Got any excel Question?