| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
average of different cells ignoring zero values
i wanna calculate average value of cells not in a same row or column ignoring
the zero value if it is there in any cell. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
average of different cells ignoring zero values
=sumif(highlight your values,0)/countif(highlight your values,0)
"awais" wrote: i wanna calculate average value of cells not in a same row or column ignoring the zero value if it is there in any cell. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to calculate average value in a row ignoring values below "x" | Excel Discussion (Misc queries) | |||
| Ignoring blank cells on getting an average | Excel Discussion (Misc queries) | |||
| Calculate the average of numbers, ignoring multiple values | Excel Discussion (Misc queries) | |||
| average values in non-contiguous cells, ignoring 0 values | Excel Worksheet Functions | |||
| 30 Day Moving Average Ignoring Blank Cells | Excel Worksheet Functions | |||
Linear Mode
