Explainry Tutorials to Expert in IT

Count cells if contain negative numbers

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


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.


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