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.

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

--

HTH

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


"Patty R." <Patty wrote in message
...
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.

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 wrote in message
...
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.

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

Vaya con Dios,
Chuck, CABGx3


"Patty R." <Patty wrote in message
...
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.

Or somewhat shorter and probably faster

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


--

Regards,

Peo Sjoblom



"CLR" wrote in message
...

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

Vaya con Dios,
Chuck, CABGx3


"Patty R." <Patty wrote in message
...
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

=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 wrote in message
...
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:

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 wrote in message
...
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.

Can you explain what you mean with data?

--

HTH

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


"Patty R" <Patty wrote in message
...
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 wrote in message
...
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.