Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Add items in column 3 if column 1 and 2 conditions are met
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
count unique with conditions | Excel Worksheet Functions | |||
match and count words | Excel Worksheet Functions | |||
up to 7 functions? | Excel Worksheet Functions | |||
how can I list items in a column with totals? | Excel Discussion (Misc queries) | |||
How can I sort an entire spreadsheet from a list | Excel Worksheet Functions |