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

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.
 
B

Bruno Campanini

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
Sorting out negative numbers 2
How to count the maximum number of consecutives? 9
Excel How to add numbers in same cell? 2
add only positive numbers and avg in a column 6
SUMIF with criteria "<>" & "=" 4
I have a column of 50 numbers 1
Need Help with "SUM" AND "ABS" in same formula 12

Top