I want to only add up the negative numbers in a column, not the positive ones.

Question

In lieu of using double entry bookkeeping, I have my finances in Excel columns. I enter positive numbers for the deposits and negative numbers when I spend. In addition to the total in the bottom cell of each column, I want to show a expenditure total in a cell below that. Can't figure out how to just add up the negative amounts in a column.&nbsp; Please advise.&nbsp; John

sergeibaklan · Answer

papajohn&nbsp;
John, in general it's better to have two columns for such purposes. But if in one, you may sum as
= -SUMIF(B:B,"&lt;0")
or which range do you use.

papajohn · Answer

SergeiBaklan&nbsp;Thanks very much. That is exactly what I needed.

sergeibaklan · Answer

papajohn&nbsp;, you are welcome

Forum Discussion

I want to only add up the negative numbers in a column, not the positive ones.

3 Replies

Resources