View Single Post
  #4   Report Post  
Myrna Larson
 
Posts: n/a
Default

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