Function newbie

[Rubix]

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

 

[Bob Phillips]

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

--

HTH

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

 

[Rubix]

Thanks.