View Single Post
  #1   Report Post  
Todd Nelson
 
Posts: n/a
Default disregarding empty fields during average

What formula can I use that will disregard the fields that are either blank
or "0" when averaging a block of cells?