The COUNTIF function is used to counts cells based on a single criterion. e.g. we can use the function to count cells if contain positive numbers.
How the formula works
The formula used has following arguments:
range (B5:B9) – The range of cells to count based on the criteria.
criteria (“>0”) – The criteria to count only those cells which have positive numbers.