Thread: Average across worksheets ignoring zero
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ted Ted is offline
external usenet poster
  
Posts: 48
Default Average across worksheets ignoring zero
I am using =AVERAGE(Start:End!F37) to calculate an average across multiple
worksheets. However, some of the sheets contain a zero in cell B37. I need
to ignore that zero (and that sheet) entirely. Can anyone help?
Reply With QuoteReply With Quote