Averaging cells with values

[andrewb90]

I have cells B9,B11,B13,B15, and B17 that I need averaged. However, I don't want to include any cells that don't have a numerical value. Those cells all have a formula similar to this:

=IF(B22>0,B22,"-")

So any cells that display: '-' should not be included. Is this doable, because I am having a tough time with this.

Thanks,

Andrew

 

[Marcelo Branco]

Hi,

You can use this
=AVERAGE(B9,B11,B13,B15,B17)

the AVERAGE function doesn't evaluate cells with "-"

M.

 

[andrewb90]

what about if the cells equal 0?

 

[Marcelo Branco]

Take a look at
Conditional Average On Non-Contiguous Ranges Using FREQUENCY() | RAD Excel

M.