#DIV/0 ERROR in AVERAGING

[Patty R.]

I am creating a worksheet for 2005 calendar year that shows averages.

AVERAGE(C6:AG6)

However, when I the cells are empty the #div/0! displays. I have been
trying to do the IF Function to display a 0 if there is nothing to Average.

Any help is greatly appreciated.

Thanks,
Patty R.

[CLR]

=IF(ISERR(AVERAGE(C6:AG6)),0,AVERAGE(C6:AG6))

Vaya con Dios,
Chuck, CABGx3


"Patty R." <Patty [email protected]> wrote in message
news:[email protected]...
> I am creating a worksheet for 2005 calendar year that shows averages.
>
> AVERAGE(C6:AG6)
>
> However, when I the cells are empty the #div/0! displays. I have been
> trying to do the IF Function to display a 0 if there is nothing to
Average.
>
> Any help is greatly appreciated.
>
> Thanks,
> Patty R.

[Bob Phillips]

=IF(SUM(C6:AG6)=0,0,AVERAGE(C6:AG6))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Patty R." <Patty [email protected]> wrote in message
news:[email protected]...
> I am creating a worksheet for 2005 calendar year that shows averages.
>
> AVERAGE(C6:AG6)
>
> However, when I the cells are empty the #div/0! displays. I have been
> trying to do the IF Function to display a 0 if there is nothing to
Average.
>
> Any help is greatly appreciated.
>
> Thanks,
> Patty R.

[Dave R.]

One way - which will still show errors in averaging if they occur (as
opposed to IF(ISERROR(....) ) ;

=IF(SUMPRODUCT(--(C6:AG6=""))=COLUMNS(C6:AG6),0,AVERAGE(C6:AG6))




"Patty R." <Patty [email protected]> wrote in message
news:[email protected]...
> I am creating a worksheet for 2005 calendar year that shows averages.
>
> AVERAGE(C6:AG6)
>
> However, when I the cells are empty the #div/0! displays. I have been
> trying to do the IF Function to display a 0 if there is nothing to
Average.
>
> Any help is greatly appreciated.
>
> Thanks,
> Patty R.

[Peo Sjoblom]

Or somewhat shorter and probably faster

=IF(COUNT(C6:AG6),AVERAGE(C6:AG6),0)


--

Regards,

Peo Sjoblom



"CLR" <[email protected]> wrote in message
news:[email protected]...
>
> =IF(ISERR(AVERAGE(C6:AG6)),0,AVERAGE(C6:AG6))
>
> Vaya con Dios,
> Chuck, CABGx3
>
>
> "Patty R." <Patty [email protected]> wrote in message
> news:[email protected]...
> > I am creating a worksheet for 2005 calendar year that shows averages.
> >
> > AVERAGE(C6:AG6)
> >
> > However, when I the cells are empty the #div/0! displays. I have been
> > trying to do the IF Function to display a 0 if there is nothing to
> Average.
> >
> > Any help is greatly appreciated.
> >
> > Thanks,
> > Patty R.
>
>

[Steve R]

Patty

=IF(ISERROR(AVERAGE(C6:AG6)), 0,AVERAGE(C6:AG6))

Based on your question, this will give month-to-date average. You need to be
mindful that a zero needs to be entered as approproate to maintain a proper
running average.

Steve



"Patty R." <Patty [email protected]> wrote in message
news:[email protected]...
>I am creating a worksheet for 2005 calendar year that shows averages.
>
> AVERAGE(C6:AG6)
>
> However, when I the cells are empty the #div/0! displays. I have been
> trying to do the IF Function to display a 0 if there is nothing to
> Average.
>
> Any help is greatly appreciated.
>
> Thanks,
> Patty R.

[Patty R]

Bob:

Your formula worked for my Daily numbers. However, the cell is linked to
the Monthly cell and it is not averaging correctly with the other months.
Any suggestions?

Patty



"Bob Phillips" wrote:

> =IF(SUM(C6:AG6)=0,0,AVERAGE(C6:AG6))
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "Patty R." <Patty [email protected]> wrote in message
> news:[email protected]...
> > I am creating a worksheet for 2005 calendar year that shows averages.
> >
> > AVERAGE(C6:AG6)
> >
> > However, when I the cells are empty the #div/0! displays. I have been
> > trying to do the IF Function to display a 0 if there is nothing to
> Average.
> >
> > Any help is greatly appreciated.
> >
> > Thanks,
> > Patty R.
>
>
>

[Bob Phillips]

Can you explain what you mean with data?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Patty R" <Patty [email protected]> wrote in message
news:[email protected]...
> Bob:
>
> Your formula worked for my Daily numbers. However, the cell is linked to
> the Monthly cell and it is not averaging correctly with the other months.
> Any suggestions?
>
> Patty
>
>
>
> "Bob Phillips" wrote:
>
> > =IF(SUM(C6:AG6)=0,0,AVERAGE(C6:AG6))
> >
> > --
> >
> > HTH
> >
> > RP
> > (remove nothere from the email address if mailing direct)
> >
> >
> > "Patty R." <Patty [email protected]> wrote in message
> > news:[email protected]...
> > > I am creating a worksheet for 2005 calendar year that shows averages.
> > >
> > > AVERAGE(C6:AG6)
> > >
> > > However, when I the cells are empty the #div/0! displays. I have been
> > > trying to do the IF Function to display a 0 if there is nothing to
> > Average.
> > >
> > > Any help is greatly appreciated.
> > >
> > > Thanks,
> > > Patty R.
> >
> >
> >