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.
|