Thread: formula(excel) to skip cells having - number and add + one
View Single Post
  #2   Report Post  
Bruno Campanini
 
Posts: n/a
Default formula(excel) to skip cells having - number and add + one
"anthonylaw" wrote in message
...
pls help me with the formula in excel to add up the cells having only
positve
numbers and to skip the cells having a negative numbers.
thank u.

=SUMIF(Range,"0")

Bruno


Reply With QuoteReply With Quote