Explainry Tutorials to Expert in IT

Count cells if contain positive numbers

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.



Copyright © 2016 - 2020 Explainry.com | All Rights Reserved