Change the D6 formula to =IF(ISERROR(AVERAGE(D7:D10)),"",AVERAGE(D7:D10))

But be careful taking the average of averages. Are you sure that you don't
need a weighted mean?
--
David Biddulph

"delete automatically" wrote
in message ...
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?