Cell's math by logical criteria

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 ...