View Single Post
  #2  
Old 13th June 2006, 11:39 AM
jfc jfc is offline
Member
 
Join Date: Jan 1970
Location: Sydney
Posts: 402
Default

=sum(A1:C1)/countif(A1:C1, ">0")
Reply With Quote