Thread: how do I average cells if a cell is at #div/0!
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
delete automatically delete automatically is offline
external usenet poster
  
Posts: 37
Default how do I average cells if a cell is at #div/0!
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?
Reply With QuoteReply With Quote