ExcelBanter - adding and subracting credits

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - adding and subracting credits (https://www.excelbanter.com/excel-worksheet-functions/168053-adding-subracting-credits.html)

dmedina

adding and subracting credits

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

adding and subracting credits

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" wrote:

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.

dmedina

adding and subracting credits

Thank you, that worked!

"Elkar" wrote:

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" wrote:

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.

All times are GMT +1. The time now is 12:03 AM.