#DIV/0! error for Averages

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.

hi,
you can try something like this:
=IF(G10=0,"",AVERAGE(F10,G10))
I don't know you data lay out so this may not fit your
data exactly but it is a average if formula.
tested and it works.

-----Original Message-----
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.
.

Will this work?

=if(iserror(AVERAGE('3.2More Details'!
Q4:Q1500)),"",AVERAGE('3.2More Details'!Q4:Q1500))

-----Original Message-----
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.
.

Try =IF(iserror(AVERAGE('3.2 More Details'!Q4:Q1500)),"",AVERAGE('3.2 More
Details'!Q4:Q1500))

This should leave the cell blank if there is an error, but give you the
average if there is no error.

Hope it helps.

"dandigger" wrote:

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.

Hi
try:
=IF(COUNT('3.2 More Details'!Q4:Q1500),AVERAGE('3.2 More
Details'!Q4:Q1500),"")

--
Regards
Frank Kabel
Frankfurt, Germany

"dandigger" schrieb im
Newsbeitrag ...
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.

The =If(iserror(.... works just fine. I thank you very much cwilson and Patti.
I love Excel!

"cwilson" wrote:

Try =IF(iserror(AVERAGE('3.2 More Details'!Q4:Q1500)),"",AVERAGE('3.2 More
Details'!Q4:Q1500))

This should leave the cell blank if there is an error, but give you the
average if there is no error.

Hope it helps.

"dandigger" wrote:

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.