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.

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.