Question

Example of Sumproduct function in excel

Answer 1

SUMPRODUCT treats non-numeric items in arrays as zeros.

Array arguments must must be the same size. Otherwise, SUMPRODUCT will generate a #VALUE! error value.

Logical tests inside arrays will create TRUE and FALSE values. In most cases, you'll want to coerce these to 1's and 0's.

SUMPRODUCT can often use the result of other functions directly (see formula examples below)