After you add the last range you want to include in calculations, add a set of parentheses enclosing all the involved ranges, so that the entire calculation is enclosed. Repeat steps 3 and 4 to enter additional ranges and operators for your calculations. This is the operation you will perform using the cells that meet any criteria you include you can include more operators and ranges. For example, to include the column Sales from the table Table1, type (Table1).Įnter an arithmetic operator: *, /, +,. Type (, enter or select a range of cells to include in your calculations, then type ). You can use arrays that evaluate as True or False (1 or 0) as criteria by using them as factors (multiplying them by the other arrays).įor example, suppose you want to calculate net sales for a particular sales agent by subtracting expenses from gross sales, as in this example.Ĭlick a cell outside the ranges you are evaluating. SUMPRODUCT takes arrays and arithmetic operators as arguments.
When you need to perform simple arithmetic calculations on several ranges of cells, sum the results, and use criteria to determine which cells to include in the calculations, consider using the SUMPRODUCT function.
