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.
- GreyNomadMay 16, 2025Copper Contributor
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.