how do I add only positive numbers in a range
 

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

how do I add only positive numbers in a range
 

Try this:

=SUMIF(A1:A10,"0")

Biff

"jpmmgr" wrote in message
...
have both positive and negative numbers in a column or row but only wish
to
SUM positive numbers and disregard the negative numbers

how do I add only positive numbers in a range
 

Thanks Biff was a great help
jpmmgr

"Biff" wrote:

Try this:

=SUMIF(A1:A10,"0")

Biff

"jpmmgr" wrote in message
...
have both positive and negative numbers in a column or row but only wish
to
SUM positive numbers and disregard the negative numbers

how do I add only positive numbers in a range
 

You're welcome. Thanks for the feedback!

Biff

"jpmmgr" wrote in message
...
Thanks Biff was a great help
jpmmgr

"Biff" wrote:

Try this:

=SUMIF(A1:A10,"0")

Biff

"jpmmgr" wrote in message
...
have both positive and negative numbers in a column or row but only
wish
to
SUM positive numbers and disregard the negative numbers