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.