Function newbie

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" <[email protected]> wrote in message
news:[email protected]...
> 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"
<[email protected]> wrote:

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