Free Online Tutorials on Spreadsheets

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 | All Rights Reserved