Hi - looking for a solution to keep track of bank transaction in a budget - both in and out
With:
=SUMPRODUCT(--(Table[[CAT]:[CAT]]=$C5);--(Month(Table[[DATE]:[DATE]])=G$3);--(Table[[IN]:[IN]]))
Table1:
DATE | CAT | IN | OUT
----------------------
the transaction CATegory and Date place the amount from table - column IN to the corresponding cell in my budget.
I would like my bank account to reflect both income an expenses from 2 columns in Table: IN and OUT.
Can't figure out how to implement this in the above formula.
Greatful for any help
Workbook example:
(see earlier post: http://www.excelforum.com/excel-form...h-problem.html)
Thanks to TMS
Nordmann
Bookmarks