View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Melissa Melissa is offline
external usenet poster
 
Posts: 122
Default how to specify "not equal to"?

To give a simple example, I would like to sum a range of cells only if the
values are not 0. So the sum should include both positive and negative
numbers. What would the formula look like?
Thank you very much.