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?
|