What formula will count the number of data < 0 in a column?

J

JackieB

I have a list with values from -50 to + 50. I need a formula that will
produce the percentage of values in that column less than zero.
 
M

Martin P

If the range is A1:A4:

=COUNTIF(A1:A4,"<0")/COUNT(A1:A4)*100

Since COUNTIF and COUNT cover the same range, it would be convenient to name
the range.
 
Top