This post will guide you how to count cells that contain positive or negative numbers in Excel. How do I count positive and negative values with a formula in Excel. How to count all negative number or positive number in a given range of cells in Excel.
Count Positive or Negative Numbers
If you want to count the number of cells that contain negative numbers or positive numbers in a range of cells in Excel, you can create a formula based on the COUNTIF function.
For example, you have a range of cells (A1:C4) that contain negtive and positive numbers, and you want to count only positive numbers, you can use the following formula:
Type this formula into a cell, and press Enter key.
You will see that the number of positive values in the given range will be counted.
The COUNTIF function will count the number of cells in the given range that match the supplied criteria. so if the value in range is greater 0, then it indicated that this value is a negative number.
If you want to count the number of only negative numbers in the range of cells A1:C4, just use the following formula:
- Excel COUNTIF function
The Excel COUNTIF function will count the number of cells in a range that meet a given criteria. This function can be used to count the different kinds of cells with number, date, text values, blank, non-blanks, or containing specific characters.etc.= COUNTIF (range, criteria)…