Formula to add up numbers but there are negatives

  • Thread starter Thread starter Noodlenix
  • Start date Start date
N

Noodlenix

Hi,
I want a formula that will just add up the total numbers and disregard the
negatives, is there a true value formula?
 
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.
 
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))
 
Back
Top