The SUMPRODUCT function multiplies the elements of one or more arrays and then adds the products. By modifying the form of its arguments, SUMPRODUCT counts the number of cells in a given range containing data that meet specific criteria.
How to use SUMPRODUCT in Excel
The syntax of a function refers to the layout of the function and includes the function name, parentheses, commas, and arguments.
To get a function that counts cells instead of holding data, the following syntax is used with SUMPRODUCT:
Normally, the best way to enter functions in Excel is through the Function Arguments dialog box (in Excel for Mac, use the Formula Builder). The dialog box lets you easily enter arguments one at a time without having to type the parentheses or commas that separate the arguments.