Tom,
in the last post i gave you the formula that i am using. I don't know if
this is pertinent or not, but the cells i am pulling from all have =average
formulas in them. What i am really trying to do is get an average of the
averages. those formulas are all the same =average(05:035). that's oh 5 and
oh 35, not zeros.
"ucastores" wrote:
=AVERAGE(BVB!O41,HMC!O41,VVRMC!O41,VBMC!O41) This is the formula i have set
up. If i run it as it is i get the error, if i remove the HMC one, which is
blank, i get an average.
"Tom Hayakawa" wrote:
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?
|