|
|||
This useful tool performs mathematical calculations (adding, counting, finding highest, etc.), using cells that meet a given criteria (greater than, less than, equal to, etc.). For this purpose, we need you to build a small decisions table, as illustrated below. Let us analyze the example: There is a small database and a decisions table. |
|||
Clicking on the proper button will bring the dialogue box. Now let us enter data, as follows: | |||
We have only taken the selected column for the analysis range. Click on the OK button. The results will be displayed in the following figure: |
|||
Results interpretation: The values between 0 and 3 add up to $4.00; values appearing between 4 and 6 add to $5.00; and so on ... |
|||