How do I count how many positive and negative numbers in a couumn
 

I need to count how many entries in a coumn and then how many of the numbers
are positive and how many negative. I know this is 3 cells, I want it to say
8 winners and 3 losers 11 total. I know how to do the count for the total
number, but how do I get the winners and losers?
--
Thanks Very Much!

Art Nittskoff

How do I count how many positive and negative numbers in a couumn
 

countif

Art Nittskoff wrote:
I need to count how many entries in a coumn and then how many of the numbers
are positive and how many negative. I know this is 3 cells, I want it to say
8 winners and 3 losers 11 total. I know how to do the count for the total
number, but how do I get the winners and losers?
--
Thanks Very Much!

Art Nittskoff

How do I count how many positive and negative numbers in a couumn
 

Count the positives this way:

=COUNTIF(A1:A100)

and the negatives this way:

=COUNTIF(A1:A10<0)

Alternatively, you could add a helper column in which you run the following
formula down the length of the column: =IF(A1<0,"Loser","Winner") and then
use countif to count the number of "Loser" and "Winner" identifications.

Adjust the range and cell references above to suit your needs.

Dave

--
Brevity is the soul of wit.


"Art Nittskoff" wrote:

I need to count how many entries in a coumn and then how many of the numbers
are positive and how many negative. I know this is 3 cells, I want it to say
8 winners and 3 losers 11 total. I know how to do the count for the total
number, but how do I get the winners and losers?
--
Thanks Very Much!

Art Nittskoff

How do I count how many positive and negative numbers in a couumn
 

Hi Art,

Try something like this.

="There are "&COUNTA(A1:A6)&" total, "&COUNTIF(A1:A6,"<1")&" loosers,
"&COUNTIF(A1:A6,"0")&" winners."

HTH
Regards,
Howard


"Art Nittskoff" wrote in message
...
I need to count how many entries in a coumn and then how many of the
numbers
are positive and how many negative. I know this is 3 cells, I want it to
say
8 winners and 3 losers 11 total. I know how to do the count for the total
number, but how do I get the winners and losers?
--
Thanks Very Much!

Art Nittskoff