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.

Formula:

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.

Results:

 

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