D
dandigger
I know the DIV/0 has been asked many times, but I have a similar but
different problem. The formula suggestions by all for the other problem are
very helpfull and I say thanks. I have a problem using the Average function
that it returns the same error of #DIV/0!. I have a formula page that gets
values from different tabs. The formula is something like this: =AVERAGE('3.2
More Details'!Q4:Q1500)
Since there are no values (yet) in Q4 thru Q1500, I get the DIV/0 error. I'm
trying to figure out a way to not see that error message. It would be nice if
there was an AVERAGEIF function. Is there anything similar, or how can I get
this to work??!! Thanks in Advance.
different problem. The formula suggestions by all for the other problem are
very helpfull and I say thanks. I have a problem using the Average function
that it returns the same error of #DIV/0!. I have a formula page that gets
values from different tabs. The formula is something like this: =AVERAGE('3.2
More Details'!Q4:Q1500)
Since there are no values (yet) in Q4 thru Q1500, I get the DIV/0 error. I'm
trying to figure out a way to not see that error message. It would be nice if
there was an AVERAGEIF function. Is there anything similar, or how can I get
this to work??!! Thanks in Advance.