This is the kind of question that looks simple but reveals a deeper truth about how most people still wrestle with their own data. The user wants to sum income and expenses in Google Sheets, with flexible month filtering. That's a reasonable request, and the fact that it requires a forum post to solve says more about the tool than the user. We think the real problem here isn't the formula, it's that traditional spreadsheets force you to build workarounds for what should be a basic operation.
Look at what they're asking: show totals for the current month, selected months, or the full year, all while separating income from expenses. In a conventional spreadsheet, you end up nesting SUMIFS inside FILTER, or adding helper columns, or writing array formulas that break the moment you change a dropdown. It works, but it's fragile. Every new filter condition becomes another layer of complexity. The user isn't asking for something exotic, they want to see where their money came from and where it went, with a simple toggle for time periods. That's a core financial question, and the tool should answer it without a Reddit thread.
This is where the conversation gets interesting. The user's setup is perfectly logical: a table called "finanzas" with types and amounts. What's missing is a system that treats filters as first-class citizens rather than afterthoughts. In an AI-native spreadsheet, you could describe what you want in plain language: "Show me total income and total expenses for the months I select." The tool would understand the structure, apply the logic, and return the result. No formula debugging. No wondering why the sum didn't update. The human focus stays on the financial insight, not the spreadsheet mechanics.
The practical takeaway is this: if you're spending more time crafting formulas than understanding your data, the tool is holding you back. The user's problem is solvable with enough nested functions, but the better solution is a tool that adapts to how you think. Start by asking whether your spreadsheet works for you or if you're working for it. That distinction makes all the difference in how you manage your money, and your time.