Count negative cells ,count positive cells

[Chowder13037]

I have a column of cell with both negative numbers and positive numbers in the column. At the buttom I want to creat a formula that will count how many cells in the column have negative numbers and another formula that will count how many cells have positive numbers. The formula for the negative numbers will be in one cell and the positive in another cell .
Can someone help me with this .
Thanks

[ArthurReyes]

Here's the sloppy answer.

In a second column, for each cell to count
=if(A1<0,1,2)

Assuming the the above formula is Column B
=Countif(B:B,1) 'the negative values
=Countif(B:B,2) 'the positive values


[ This Message was edited by: ArthurReyes on 2002-12-10 14:32 ]

[Mudface]

For the negative nos, you could use for example: -

=COUNTIF($A$1:$A$8,"<0") where A1:A8 houses your numbers. Use ">=0" as your criteria for positive numbers (or just ">0" if you want to exclude zeros.

[ArthurReyes]

=COUNTIF($A$1:$A$8,"<0") where A1:A8 houses your numbers. Use ">=0" as your criteria for positive numbers (or just ">0" if you want to exclude zeros.

You know, I've always wondered if there was an easier way to do that! Awesome!

[3GirlKnight]

Awesome! Was looking for this solution and found it here. Thanks!

[firehat]

For the negative nos, you could use for example: -

=COUNTIF($A$1:$A$8,"<0") where A1:A8 houses your numbers. Use ">=0" as your criteria for positive numbers (or just ">0" if you want to exclude zeros.

I registered here just to applaud this answer. So.. top stuff! Saved me a lot of time!

[Drasio]

Had a question regarding this, yes it helps to count the cell #'s that are positive and negative. But is there a way to be able to add the total of the amount for the negative and positive qty's. I am trying to compare pricing from one month to another month. To what is going in and what is coming in money wise.

[Jonmo1]

Try SUMIF instead of COUNTIF

=SUMIF($A$1:$A$8,"<0")
=SUMIF($A$1:$A$8,">0")

[Drasio]

Many thanks this helped out a lot much easier to get the negative amount and the positive differences

[Jonmo1]

Glad to help, thanks for the feedback.