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