In Excel, the function is used to calculate the number and

Basic usage

The normal usage of sumproduct is

= Sumproduct (array1, array2, array3 ,...)

It supports up to 30 parameters. However, you must note that each parameter must be a numeric value and cannot be connected to a logical value.

Example

1. Click a blank space in the excel table, as shown in the following figure.

2. Then we enter the sumprouct function in the space table, and the algorithm is shown in the following figure.

3. The data shown in the box indicates the data you have collected and you can find it in the data. You can manually modify the data, or drag it with the mouse to select the data you want to collect.

4. Then we will see the results. This is mainly the sumprouct function.