I am trying to create a spread sheet were I am trying to count the
number of negative value of cells. Every negative number would add 1
to total sum cell.

Ex.

-10
-10
20
-20
-30
-10
10


Total: 5

Hope this makes sense.

Thanks,
Rube

=COUNTIF(A:A,"<0")

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Rubix" wrote in message
...
I am trying to create a spread sheet were I am trying to count the
number of negative value of cells. Every negative number would add 1
to total sum cell.

Ex.

-10
-10
20
-20
-30
-10
10


Total: 5

Hope this makes sense.

Thanks,
Rube

Thanks.

On Sat, 12 Nov 2005 10:22:21 -0000, "Bob Phillips"
wrote:

=COUNTIF(A:A,"<0")