Thread: Averaging with #N/A Cells
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
tylermdsm tylermdsm is offline
external usenet poster
  
Posts: 6
Default Averaging with #N/A Cells
i'm trying to average 5 cells. One has an #n/a value. This causes the
average to say #n/a. Is there a way to correct this?
Reply With QuoteReply With Quote