Positive and negative numbers...

[T. Valko]

To sum all the positive values:

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

To sum all the negative values:

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

 

[silas]

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

 

[T. Valko]

You're welcome!

--
Biff
Microsoft Excel MVP

I knew it was something simple.

Thank you very much.

silas

 

[Tyro]

Why did you ask in an Excel newsgroup?

 

[silas]

I knew it was something simple.

Thank you very much.

silas

 

[Tyro]

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