Formula to add up numbers but there are negatives

[Noodlenix]

Hi,
I want a formula that will just add up the total numbers and disregard the
negatives, is there a true value formula?

 

[Mike H]

Hi,

Try this

=SUMIF(A1:A6,">0",A1:A6)
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.

 

[T. Valko]

Try this...

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

 

[Dave Peterson]

Do you want to ignore the negative values or ignore the negative sign?

If you want to just add the positive numbers:
=SumIf(a1:a10,">"&0)

If you want to add all the numbers, but ignore the sign:
=sumproduct(abs(a1:a10))