how do I add only positive numbers in a range

[Guest]

have both positive and negative numbers in a column or row but only wish to
SUM positive numbers and disregard the negative numbers

 

[Biff]

Try this:

=SUMIF(A1:A10,">0")

Biff

 

[Guest]

Thanks Biff was a great help
jpmmgr

Try this:

=SUMIF(A1:A10,">0")

Biff

 

[Biff]

You're welcome. Thanks for the feedback!

Biff

Thanks Biff was a great help
jpmmgr