Count cells if contain negative numbers

Use the COUNTIF function to count cells if contain negative numbers.

Formula:  

How the formula works

The formula used above to count negative values has following arguments:

range (B5:B9) – The range of cells to count based on the criteria.

criteria “<0” – The criteria to count if cells contain negative values only.

Result:

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