Excel Formulas - Count number of cells that contain positive or negative numbers
Count number of cells containing negative numbers

Syntax of used function(s)
COUNTIF(criteria_range, criteria)
The COUNTIF function is used to count the number of cells that meet a certain criteria.
Explanation
To count number of negative numbers within a range of cells the COUNTIF function can be used.
Formula
=COUNTIF(TestData,D8)
How this formula works
In the above example the COUNTIF function search for negative number within the range assigned by the name Testdate and counts if matches.
A criteria variable have been used in this example.
Count number of cells that contain positive numbers

Explanation
To count number of positive numbers within a range of cells the COUNTIF function can be used.
Formula
=COUNTIF(TestData,D8)
How this formula works
In the above example the COUNTIF function search for positive number within the range assigned by the name Testdate and counts if matches.
A criteria variable D8 have been used in this example.
Count number of cells that contain the numbers above -60

Formula
=COUNTIF(TestData,D8)
How this formula works
In the above example the COUNTIF function search for numbers is greater than -60 within the range and counts if matches.
Here D8 is the criteria variable contain the criterai >-60.
Count number of cells that contain positive numbers and zero

Formula
=COUNTIF(TestData,D8)
How this formula works
In the above example the COUNTIF function search for numbers is greater than equal to 0 within the range and counts if matches. Here D8 is the criteria variable contain the criterai >=0.
Previous: Excel Formulas - Count cells that contain any of the specified string
Next:
Excel Formulas - Count number of cells containing even or odd numbers
- Weekly Trends and Language Statistics
- Weekly Trends and Language Statistics