![]() |
|
|
|||||||
![]() |
|
|
LinkBack | Thread Tools | Search this Thread | Display Modes |
|
|||
|
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? |
|
|||
|
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? |
![]() |
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|