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