The SUMPRODUCT function returns the sum of the products of corresponding ranges or arrays.The default operation is multiplication, but addition, subtraction, and division are also possible. In this example, we'll use SUMPRODUCT to return the total sales for a given item and size:

Before you start. Check these things before you start troubleshooting Bluetooth on your device: Check your product information. If you’re setting up a new device and Bluetooth is missing, check the product specifications to make sure it has Bluetooth capabilities.