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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Hi
=COUNTIF(A1:A100,"<0")/COUNT(A1:A100)
and format as percentage
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting text which meets a criteria 2
Pick the low number in a column of Numbers 3
If statement 5
3 COLOR SCALE CONDITIONAL FORMATING WITH FORMULAS 3
Count unique with criteria 3
make a minus a zero 2
Count of Different Columns 5
Count the columns from one sheet and paste it in another sheet 0

Back
Top