Prev: Excel character limitations
Next: filter a list of numbers
From: Noodlenix on 11 Mar 2010 12:55
Hi,
I want a formula that will just add up the total numbers and disregard the
negatives, is there a true value formula?
From: Mike H on 11 Mar 2010 13:02
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.


"Noodlenix" wrote:

> Hi,
> I want a formula that will just add up the total numbers and disregard the
> negatives, is there a true value formula?
From: T. Valko on 11 Mar 2010 13:02
Try this...

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

--
Biff
Microsoft Excel MVP


"Noodlenix" <Noodlenix(a)discussions.microsoft.com> wrote in message
news:F36BC70B-AF28-4CCB-8D9E-B6FC6B455AA3(a)microsoft.com...
> Hi,
> I want a formula that will just add up the total numbers and disregard the
> negatives, is there a true value formula?


From: Dave Peterson on 11 Mar 2010 13:04
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))

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

--

Dave Peterson
 | 
Pages: 1
Prev: Excel character limitations
Next: filter a list of numbers