Count negative cells ,count positive cells

Thanks:  0
Likes:  0

# Thread: Count negative cells ,count positive cells

1.
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

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 ]

3. 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.

4. =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!

5. ## Re: Count negative cells ,count positive cells

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

6. ## Re: Count negative cells ,count positive cells

Originally Posted by 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.
I registered here just to applaud this answer. So.. top stuff! Saved me a lot of time!

7. ## Re: Count negative cells ,count positive cells

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.

8. ## Re: Count negative cells ,count positive cells

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

9. ## Re: Count negative cells ,count positive cells

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

10. ## Re: Count negative cells ,count positive cells

Glad to help, thanks for the feedback.

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•