Thread: average of 12 noncontiguous cells
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
John Google John Google is offline
external usenet poster
  
Posts: 18
Default average of 12 noncontiguous cells
I just tried your solution (which is great!) but found that, if all
source rows are 0 (or null) you get a #DIV/0 error.

Any suggestions on how to check for this error?

John.

Reply With QuoteReply With Quote