Thread: How do i get an average that ignores blanks in the range of cells.
View Single Post
  #1   Report Post  
ucastores
 
Posts: n/a
Default How do i get an average that ignores blanks in the range of cells.
i am trying to average a range of cells, in different spreadsheets within one
worksheet but it gives me the error #div/0 when one of the cells is blank.
Any suggestions, thoughts, comments?

Reply With QuoteReply With Quote