calculate percentage of numbers <= zero in a given range

  • Thread starter Thread starter spowel4
  • Start date Start date
S

spowel4

I need to calculate the percentage of numbers, within a range of
cells, that are equal to zero or less than zero.

Simple example: numbers are 8, -1, 8, 8, 0, 0

The percentage of numbers that are equal to zero or less than zero
would be 3/6 or 50%

How can I do this in Excel?
 
Try this:

=COUNTIF(range,"<=0") / COUNT(range)

Change range to what you are using. Format the cell as percentage.

Hope this helps.

Pete
 
Back
Top