View Single Post
  #2 (permalink)  
Old 07-23-2008, 05:01 PM
Pete_UK
 
Posts: n/a
Re: calculate percentage of numbers <= zero in a given range

Try this:

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

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

Hope this helps.

Pete

On Jul 23, 4:46*pm, spowel4 <spow...@gmail.com> 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?


Reply With Quote