Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Average of cells that exclude conditional formats?
I'm trying to find the average of a range of cells that exclude points
outside the standard deviation of the cells. I found the standard deviation and made simple conditional format (cells outside STDEV are in red) rules on the cells outside of the range, but I'm not sure how to find the average excluding the formatted cells. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Average (exclude 1 min & 1 max Value) | Excel Discussion (Misc queries) | |||
Average non-adjacent cells & exclude zeros | Excel Discussion (Misc queries) | |||
conditional formats for cells | Excel Worksheet Functions | |||
conditional formats affect other cells | Excel Discussion (Misc queries) | |||
Limit or Exclude cells in Average and Sum formula | Excel Worksheet Functions |