Positive and negative numbers...

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

silas - 09 Jan 2008 04:58 GMT

Hi. I'm having some difficulty with a problem which seems like it should be
simple. In column B I have a list of money amounts, "charges", which include
the occasional negative number, "payments". In column C I need to total all
the positive numbers and in column D all the negative amounts. The formula I
tried merely totals the amounts, subtracting the negatives from the
positives. How can I have C ignore the minuses and D ignore the pluses?

Thanks.

silas

Reply to this Message

T. Valko - 09 Jan 2008 05:24 GMT

To sum all the positive values:

=SUMIF(B:B,">0")

To sum all the negative values:

=SUMIF(B:B,"<0")

Signature

Biff
Microsoft Excel MVP

> Hi. I'm having some difficulty with a problem which seems like it should
> be simple. In column B I have a list of money amounts, "charges", which
[quoted text clipped - 7 lines]
>
> silas

Reply to this Message

silas - 09 Jan 2008 06:18 GMT

I knew it was something simple.

Thank you very much.

silas

> To sum all the positive values:
>
[quoted text clipped - 15 lines]
>>
>> silas

Reply to this Message

T. Valko - 09 Jan 2008 06:37 GMT

You're welcome!

Signature

Biff
Microsoft Excel MVP

>I knew it was something simple.
>
[quoted text clipped - 21 lines]
>>>
>>> silas

Reply to this Message

Tyro - 09 Jan 2008 06:51 GMT

Why did you ask in an Excel newsgroup?

> Hi. I'm having some difficulty with a problem which seems like it should
> be simple. In column B I have a list of money amounts, "charges", which
[quoted text clipped - 7 lines]
>
> silas

Reply to this Message

Tyro - 09 Jan 2008 07:21 GMT

It's called simple logic as you would use in real life, not just Excel.

> Hi. I'm having some difficulty with a problem which seems like it should
> be simple. In column B I have a list of money amounts, "charges", which
[quoted text clipped - 7 lines]
>
> silas

Reply to this Message