Easy Explanation Notes with Examples

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 - 2019 Explainry.com | All Rights Reserved