|
|||
Cell's math by format | |||
Use this useful tool to search all cells in a specific range with a particular background color and to do some math with the results. These are the steps: |
|||
3. Select the range containing the colors to be searched. 4. Decide which sheets contain the same range to be searched. 5. The results may be pasted either as values or as formulas. Try for yourself. 6. Select the cell(s) you want to paste the results in. |
|||
Observation: Excel doesn't allow to create formulas that contains too many characters. If the operation's result, that you executed, thrown excessive characters, then Cell's math by format will inform you, and it, optionally, let you to paste the results of your operation, but only as values. This is a good alternative. |
|||
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 ... |