#DIV/0 ERROR in AVERAGING

[Guest]

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)

 

[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))

 

[CLR]

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

Vaya con Dios,
Chuck, CABGx3

 

[Peo Sjoblom]

Or somewhat shorter and probably faster

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


--

Regards,

Peo Sjoblom

 

[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

 

[Guest]

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]

Can you explain what you mean with data?

--

HTH

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