T
T. Valko
To sum all the positive values:
=SUMIF(B:B,">0")
To sum all the negative values:
=SUMIF(B:B,"<0")
=SUMIF(B:B,">0")
To sum all the negative values:
=SUMIF(B:B,"<0")
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
S
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
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
T. Valko
You're welcome!
--
Biff
Microsoft Excel MVP
--
Biff
Microsoft Excel MVP
silas said:I knew it was something simple.
Thank you very much.
silas
T
Tyro
Why did you ask in an Excel newsgroup?
S
silas
I knew it was something simple.
Thank you very much.
silas
Thank you very much.
silas
T
Tyro
It's called simple logic as you would use in real life, not just Excel.