Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
trying to make a formula for percent if greater than a value
I am trying to create a formula that will calculate percent survival.
Basically I have data in cells and I want to make a fomula that tests if there is a value greater than 0. I want my answer to be not the values in the box, but the number of cells with data greater than zero divided by the total number of cells. Then, I'd like to write another formula to average the values in those cells, but only if those cells have a value greater than zero. Can anyone help? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula for selecting the greater of two values? | Excel Worksheet Functions | |||
Is it possible? | Excel Worksheet Functions | |||
How do I make this formula? | Excel Discussion (Misc queries) | |||
how do I make a formula NOT change when the data range is moved? | Excel Discussion (Misc queries) | |||
How to make a formula display results only if value is greater tha | Excel Discussion (Misc queries) |