Function newbie

R

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
 
B

Bob Phillips

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

--

HTH

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