formula(excel) to skip cells having - number and add + one

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
anthonylaw said:
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.
Click to expand...

=SUMIF(Range,">0")

Bruno
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Divide two cells and if the number is negative display is as zero 2
Red cell for negative numbers in Excel 1
I have a column of 50 numbers 1
Sorting out negative numbers 2
Excel How to add numbers in same cell? 2
I have a column of 50 numbers 5
Calculating new date by entering number of additional workdays 1
I have a column of 50 numbers 1

Back
Top