Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
from a group of cells.find average of cells containing values
average some specified cells using only those with values greater then 0
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
from a group of cells.find average of cells containing values
"farm" wrote: average some specified cells using only those with values greater then 0 Hi Try =SUM(A1:A6)/COUNTIF(A1:A6,"0") where A1 to A6 is the range Regards Peter |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
average values in non-contiguous cells, ignoring 0 values | Excel Worksheet Functions | |||
Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
Average the Last Five Cells in a Column | Excel Worksheet Functions | |||
Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions | |||
copy group of cells to another group of cells using "IF" in third | Excel Worksheet Functions |