Count value types in a column of data

There are times when you want to know how many negative or positive values there are in a column. When would you want this information, well who knows but I bet you will sleep better know how to do it.

You want to use the COUNTIF function. You simply identify the column of data that you want to count and then for the criteria put >0. Now in order for this to work, you need to put quotes around >0.

And I bet by now you have guessed that you could count the negative values just by reversing the >0

=COUNTIF(B:B,">0")     Returns the number of positive numbers in a range
=COUNTIF(B:B,"<0")     Returns the number of negative numbers in a range


No comments:

Post a Comment