Counting Positives and Negatives

If column A contains positive and negative numbers, you may need to count how many of each. You can use the following two formulas.

Positives

=COUNTIF(A:A,">0")

Negatives

=COUNTIF(A:A,"<0")

Zeroes

There may be zeroes as well. The formula to count them is

=COUNTIF(A:A,0)

Related Posts