There is a better way to handle this than wrestling with nested formulas for hours. The user's problem, multiplying costs by cumulative percentages across years, then filtering for specific items like "wood", is a classic spreadsheet headache that should have been solved years ago. Instead, we see someone manually guessing at `SUMPRODUCT` syntax, hoping to avoid a tedious row-by-row grind. That is not a skill gap. That is a tool gap.
Here is what this means in practical terms: every minute spent debugging a formula like this is a minute stolen from understanding the data itself. The user has a clear business question, how much did I pay by the end of year two for certain items?, but the spreadsheet forces them to translate that question into arcane cell references and conditional logic. The percentages accumulate, the items have names to filter, and the table structure is rigid. Traditional spreadsheets treat this as a puzzle to solve. A modern, AI-native approach would treat it as a conversation: "Show me the running total for wood items across all years." No formula required.
The frustration here is not unique. It is the daily reality for anyone managing inventory, budgets, or project costs across time. The user has "way too many items" to do it manually, yet the spreadsheet offers no better path. They are left searching forums, copying snippets, and hoping the syntax works. That is not productivity; it is survival. An AI-powered spreadsheet would understand the intent behind the question, apply the cumulative logic automatically, and respect the filter condition without forcing the user to become a part-time programmer.
Our take is plain: spreadsheets should adapt to how people think, not the other way around. The user should be able to ask, "What's the total paid by end of year 2 for all items that contain 'wood'?" and get the answer instantly. No `SUMPRODUCT`, no manual column multiplication, no forum posts. That is the standard we should expect. And it is the standard we are building toward.