Hi, Bob:

How about COUNT instead of SUM?


On Tue, 15 Mar 2005 16:19:27 -0000, "Bob Phillips"
wrote:

=IF(SUM(A1:A4)=0,"",AVERAGE(A1:A4))