| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate Percentage of True (or False) in a range | Excel Discussion (Misc queries) | |||
| calculate percentage in pivot | Excel Discussion (Misc queries) | |||
| calculate percentage | Excel Worksheet Functions | |||
| Forumla to calculate a percentage | Excel Discussion (Misc queries) | |||
| calculate percentage of two cells | Excel Worksheet Functions | |||
Linear Mode
