andrewb90
Well-known Member
- Joined
- Dec 16, 2009
- Messages
- 1,077
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:
So any cells that display: '-' should not be included. Is this doable, because I am having a tough time with this.
Thanks,
Andrew
Code:
=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