# SUMPRODUCT

SUMPRODUCT function can be use in place of SUMIFS and COUNTIFS since it addressed lots of their limitations in Excel. Syntax: SUMPRODUCT(array,[array1],[array2],…) It simply takes one or more arrays of numbers then test for TRUE or FALSE answer with the numerical equivalent of 1 being TRUE or 0 being FALSE (that is Excel should[…]