Thread: My Final #DIV/0! that I'd like to say Goodbye to!
View Single Post
  #16   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Thomas Dave Thomas is offline
external usenet poster
  
Posts: 146
Default My Final #DIV/0! that I'd like to say Goodbye to!
We can put this whole issue to rest with:

=IF(COUNT(DATA)+COUNTBLANK(DATA)=ROWS(DATA),IF(COU NT(DATA),AVERAGE(DATA),""),"Houston,
we have a problem")



Reply With QuoteReply With Quote