| 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 | |||
Linear Mode
