calculate percentage of numbers <= zero in a given range
 

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?

calculate percentage of numbers <= zero in a given range
 

See your other post for an answer - please do not multipost.

Pete

On Jul 23, 4:47*pm, spowel4 wrote:
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?

calculate percentage of numbers <= zero in a given range
 

=COUNTIF(A1:A6,"<=0")/COUNT(A1:A6) and format as percentage.
--
David Biddulph

"spowel4" wrote in message
...
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?

calculate percentage of numbers <= zero in a given range
 

Try this:

=COUNTIF(A1:F1,"<=0")/COUNT(A1:F1)

Format as percentage

--
Biff
Microsoft Excel MVP


"spowel4" wrote in message
...
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?