btafluid.blogg.se

The standard arithmetic operations applied to the data on the spreadsheets are addition, subtraction, multiplication, and division.

Numbers are everywhere, from calculating salary, budget allocation, inventory management, and sales forecast. Your completed formula might look like the one in our example above: =SUMPRODUCT(((Table1)-(Table1))*(Table1=B8)), where cell B8 holds the agent name.The most basic and often used function is the subtract function. If you have more criteria, repeat step 6 as needed. This causes the cells to evaluate as 1 or 0, so when multiplied by other values in the formula the result is either the same value or zero - effectively including or excluding the corresponding cells in any calculations. To enter a range to use as a criterion, type *, enter the range reference normally, then after the range reference but before the right parenthesis, type =", then the value to match, then ". You may need to include additional parentheses inside your calculation to group various elements, depending on the arithmetic you want to perform. 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.