Use the Count If Greater Than Function in Excel  Guide ▷ 2020

Microsoft Excel is an office automation tool that has many functions that simplify administrative tasks. For example, the Excel function “Count if” with criterion “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 marketed product in your inventory. In this sense, this 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

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

For this reason, we show you step by step how to use the “Count If” function with “Greater Than” criteria in Excel:

  • To use the COUNTIF function, you must enter: = COUNTIF (range; search criteria)

Remember that all formulas used in Excel, are preceded by the equal sign. Its omission makes the program treat the function as simple 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. Keep in mind that in the syntax, the range must be kept separate from the search criteria by means of a semicolon.

For better understanding, pay attention to the following examples:

  • With a term = COUNTIF (D3: D6; ”pants”)
  • With a cell = COUNTIF (D3: D6; G9)

Based on the above, you can use the criteria “GREATER THAN” to find out 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:

  • = COUNTIF(range; ”> search criteria”)

In said syntax, it is essential to use quotes since a text character is being combined with a number.

For example, if you want to know what are the values ​​greater than 20 in a certain range, the function must be expressed as follows:

  • = COUNTIF(D3: D6; ”> 20”)

In the event that you do not know the value corresponding to the search criteria, the syntax changes a bit. For example, the largest number is in a cell.

In this situation, you must enter the following formula:

  • = COUNTIF(D3: D6; ”>” & C4)

It should be noted that cell C4 is where the function will return the Outcome. Finally, you can also use the tool COUNT YES to determine a value greater than or equal to.

In this case, the syntax would be:

  • = COUNTIF(D3: D6; ”> = 20”)

Variation includes the equal sign enter the greater than symbol (>) and the value of the criterion search.

Other useful Excel functions to organize your accounts

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 features to organize your accounts:

SUM

It is a function that is in charge of 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 do a combination of the three categories.

The syntax used for the SUM function are the following:

  • = SUM (D4: D10) It is the formula to add the values ​​from the starting cell to the ending cell.
  • = SUM (D4: D10, F4: F10) It is in charge of adding the values ​​of two different ranges.

SUBTRACTION

In excel subtraction is possible, but there is no SUBTRACT function. For a simple subtraction, you just have to 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 number in negative. To do this, you use the function of SUM. The syntax would be the following: = SUM (100, -25) or = SUM (B2-B4)

PERCENTAGES

Another possibility it 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, you just need to divide both figures.

For example:

  • A4: 60,000
  • B4: 10,000
  • C4: Resulting cell.

Based on the data provided, 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 “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.

If you have any questions, leave them in the comments, we will answer you as soon as possible, and it will surely be of great help to more members of the community. Thank you! 😉

You may be interested:

Rate this post

Leave a Comment