Try this.

=IF(SUM(B6:B24)0,AVERAGE(B6:B24),0)

Mike

"chedd via OfficeKB.com" wrote:

Hi

I wish to return a zero value in the total cell when there is no data in the
column cells. At present it is showing #DIV/0! in the total cell. The
formula i am using at the moment is =AVERAGE(B6:B24). Please can help with
this query.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200704/1