Forum Discussion

papajohn's avatar
papajohn
Copper Contributor
Apr 24, 2020

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

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 cel...
excel
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Apr 24, 2020

papajohn 

John, in general it's better to have two columns for such purposes. But if in one, you may sum as

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

or which range do you use.

  • papajohn's avatar
    papajohn
    Copper Contributor
    Apr 24, 2020

    SergeiBaklan 

    Thanks very much. That is exactly what I needed.

Resources