View Single Post
  #1   Report Post  
Cheryl McHarg
 
Posts: n/a
Default sum numbers only when a named cell is not zero

In my spreadsheet, I need cell L10 to sum cells ( M10-P10) if P10 does not
equal zero. P10 is a formula=+n10+O10.