Microsoft Excel It is an office tool that has many functions that simplify administrative tasks. For example, Excel function “Count if” with criteria “Greater than” in a spreadsheet. If you want to know how to use it, keep reading this step by step guide.
"Count Yes" it is a tool for statistical purposes. Used to determine the most relevant data in a data area. It consists of the combination of two functions: YES (Logical function) and TELL (Statistical function).
This tool is very useful. For example, if you want know which is the most commercialized product in your inventory. In this sense, said function is easy to apply when you understand it correctly, so we will explain the step by step.
Learn step by step how to use the Count If function with Greater Than criteria in Excel
In all excel formula, It's fundamental enter the correct syntax for the functions to work correctly.
For this reason, we teach you step by step how to use the “Count If” function with “Greater Than” criteria in Excel:
- To use the COUNT YES function, you must enter: = COUNT YES (range; search criteria)
Remember that all the formulas used in Excel, are preceded by the equal sign. Its omission causes the program to view the function as single characters entered in a cell. The range represents the cells in which the collected data is located. In this section start cell and end cell must be specified. These cells must be separated by a colon. For example, "D3: D6".
On the other hand, the search criteria refers to the value under consideration. When indicating the value, if it is a specific term, you must put it in quotes. On the contrary, if it is another from another cell, it is added as is. Please note that in the syntax, the range must be kept separate from the search criteria by means of a semicolon.
For further understanding, pay attention to the following examples:
- With a term = COUNT YES (D3: D6; "pants")
- With a cell = COUNT IF (D3: D6; G9)
Based on the above, you can make use of the criteria "GREATER THAN" to know if the value of a number located in a cell of a range is greater than the value of the search criteria.
The syntax to introduce would be the following:
- = COUNT YES(range; ”> search criteria”)
In such syntax, it is essential to use quotation marks because a text character is being combined with a number.
For example, if you want to know which values are greater than 20 in a certain range, the function should be expressed as follows:
- = COUNT YES(D3: D6; "> 20")
In the event that you do not know the value corresponding to the search criteria, the syntax changes a little. For example, the largest number is in a cell.
In this situation, you must enter the following formula:
- = COUNT YES(D3: D6; ”>” & C4)
It should be noted that the cell C4 is where the function will output the Outcome. Finally, you can also use the COUNT YES to determine a value greater than or equal to.
In such a case, the syntax would be:
- = COUNT YES(D3: D6; "> = 20")
Variation includes equal sign between the symbol greater than (>) and the value of the criterion of search.
Other useful Excel functions to organize your accounts
Microsoft Excel not only has the function of "Count Yes". You can also use it for more basic functions, but just as efficient for your administrative tasks.
Here are some other useful Excel functions to organize your accounts:
SUM
It is a function that is responsible for adding values by means of the sum between the numbers contained in a certain range. You can add individual values, cell ranges or references. You can even make a combination of the three categories.
The syntaxes used for the SUMA function are as follows:
- = SUM (D4: D10) It is the formula to add the values from the start cell to the end cell.
- = SUM (D4: D10, F4: F10) It is responsible for adding the values of two different ranges.
SUBTRACTION
In Excel subtraction is possible, but there is no SUBTRACT function. For simple subtraction, just add a minus sign (-). For example: = 15-5. Immediately, the result of the subtraction will appear in the cell. However, if you want to subtract the numbers from a range, you must add the same negative number. To do this, you use the function of SUM. The syntax would be as follows: = SUM (100, -25) or = SUM (B2-B4)
PERCENTAGES
Another possibility that offers you Microsoft Excel Its the get percentages through simple formulas. Percentage calculations are easy to determine. For example, if you need to find the percentage difference between two values, just divide both figures.
For example:
- A4: 60,000
- B4: 10,000
- C4: Resulting cell.
Based on the data offered, you must position yourself on cell C4 and use and enter the following syntax: = B4 / A4. The result will be reflected in the cell C4. Now go to the tab of "Start" to grant him the percentage format. On the toolbar, in the section "Number", click on the button "Percentage style" (%). In this way, the result of the division will show the percentage difference.