Excel: COUNT IF function - here's how it works

With Excel, Microsoft's spreadsheet program, you can have different numerical values calculated. Therefore, it is best used for calculating statistics and other tabular values. The COUNT IF function helps to determine a certain number of values that meet a certain condition.

How to use the COUNT IF function in Excel

The COUNT IF function works like the NUMBER function, giving you a specific section of cells to count that contain a number. However, you have the option of adding a condition that the value must meet in order to be counted.

1. Open Excel and create a table of values, for example from A3 to A12 the numbers 8 ,2 ,3 ,5 ,6 ,5 ,4 ,5 ,6, 2.
2. Now click on an empty cell and enter "=DOWNWHEN(A3:A12;">5")" there. This will show you the number 3 in this column, since 8, 6, and 6 are greater than five (>5) for the above numbers.
3. So DENTWENN counts all values that meet a certain condition. You can also use other conditions such as "<5", "London" and TIME() to count only certain values.
4. If no value is returned, although this should actually be the case, check that the condition is formulated correctly.

Excel offers many more functions. So you can hide columns or save the table as an image.