| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Create an Averaging Formula
How do you create a formula that identifies the numbers in a range of cells
that are equal to or greater than a number for example. What percentage of a set of cells contain a value greater than 80? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Create an Averaging Formula
something like this
=COUNTIF(C1:C8,"80")/COUNT(C1:C8)*100 -- Greetings from New Zealand "KBaker" wrote in message ... How do you create a formula that identifies the numbers in a range of cells that are equal to or greater than a number for example. What percentage of a set of cells contain a value greater than 80? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| averaging formula from three cells | Excel Discussion (Misc queries) | |||
| Averaging formula error | Excel Discussion (Misc queries) | |||
| Averaging with a formula | Excel Discussion (Misc queries) | |||
| Averaging Array Formula | Excel Discussion (Misc queries) | |||
| Formula for averaging times | Excel Discussion (Misc queries) | |||
Linear Mode
