Forum Discussion
IF OR statements
Personally, I would recommend an altogether different approach, as illustrated on the attached file. Keep a simple record of each transaction--what you have in your first several columns already, making sure you include a date, budget category, code for income or expense (Cash flowing In or Out), and amount. You have a choice: record income as positive, expenses as negative or use a formula based on the code to turn the amount to positive or negative in a final column.
Then let the Pivot Table do all the summarizing for you, by month and budget category. Summary is down without any formulas.
Many thanks for your suggestion. In fact, SnowMan55 came up with a very neat simple solution not involving IF/OR nor Pivot tables. Perfect for what I need to achieve. Thanks again for your help.