how do I average cells if a cell is at #div/0!
On Sep 24, 5:16 pm, delete automatically
wrote:
ok heres what I have.
in cell D6 I have formula of =AVERAGE(D7:D10) which its at #div/0!
in cell D11 = AVERAGE(D12:D15) which its at 85
in cell D16 =AVERAGE(D17:D210) which its at 50
in cell D3 I just want the average of cell D6,D11,and D16
is this possible and how?
Possible, yes. But why allow errors in your worksheet? Handle the
errors in your formulas and you won't have this problem.
=IF(ISERR0R(AVERAGE(D7:D10),0,AVERAGE(D7:D10))
|