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

[Guest]

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?

 

[Mat N]

countif

 

[Guest]

Count the positives this way:

=COUNTIF(A1:A10>0)

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

 

[L. Howard Kittle]

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