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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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
 
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
 
Back
Top