adding and subracting credits

[dmedina]

Hi
I have a total of debits and I also have some credits. What formula do I use
in order to have excel add the debits but not subtract the credits which
appear like this (32.09). It should ignore the credits.

 

[Elkar]

Try this:

=SUMIF(A1:A100,">0")

And, to SUM the Credits and ignore the Debits, you could use:

=SUMIF(A1:A100,"<0")

HTH,
Elkar

 

[dmedina]

Thank you, that worked!

Try this:

=SUMIF(A1:A100,">0")

And, to SUM the Credits and ignore the Debits, you could use:

=SUMIF(A1:A100,"<0")

HTH,
Elkar