Not quite sure what formula you're using - =AVERAGE should discount blank
cells. Could you perhaps copy the formula that's giving you a problem into a
post?
"ucastores" wrote:
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?
|