View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Larry4500
 
Posts: n/a
Default Average function with #VALUE! error in reference cells

Thank you all for the help. I tried all three and now I'm getting
either a blank, a -, or '. What I'm trying to do is make the function
average or find the median of all the cells in the range that do not
have an error. If anyone knows how to do this, I would appreciate the
help. Thanks.