Thread: Need help with DIV/0 error in an AVERAGE array formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Safety Jim Safety Jim is offline
external usenet poster
  
Posts: 1
Default Need help with DIV/0 error in an AVERAGE array formula
I am using =AVERAGE(IF(isnumber(0(C3:C8)),0(C3:C8,"")) to calculate an
average % in a column with zero's and Excel is giving me a message that the
formula is incorrect. Can anyone help?
Reply With QuoteReply With Quote