View Single Post
  #5   Report Post  
Diilb
 
Posts: n/a
Default

I was just searching the Help file for IF Statement... And found the
formula I was looking for:

=SUM(B5:B35)/COUNTIF(B5:B39,"-1")

Thanks for pointing me in the right direction :)
Diilb