This is what I am trying to do I am keeping track of my bank account using
excel. I have it set up to were I enter a category in one column and I have
columns set up for credit and debit and amount. If the item is a credit I
place an "x" in the credit column and if its a debit I place an "x" in the
debit column. On the top of the work sheet I have a running total and to the
right I have each debit broken down by category.

Questions:
1. is there a way to make the running total identify that either the credit
or debit column has an "x" in it, and if the debit column has an "x" subtract
the value in the amount column?

2. when showing each expenditrue by category is there a way to only have it
add together the values that have the debit column checked? (as it is now I
have a sumif which checks the category column for a value ex. gas, food, etc.
but I can't figure out how to have it also check the debit column)


thanks for any help you all can provide