Trust in spreadsheets needs to be earned, not assumed, as this incident perfectly illustrates. The user's mistake is simple, but the lesson it carries is profound: a filtered view is not a new dataset. When you hide rows with a filter and then sum a column, the formula still sees every cell. It does not care what is visible. It sums what is there.
The user assumed that because the rows disappeared from the screen, they disappeared from the calculation. That assumption is understandable. Spreadsheets present themselves as intuitive. They show you a table, you filter it, you see only the relevant rows, and then you sum what you see. But the underlying logic does not match the visual. The formula is blind to the filter. It reads the full range. So when this user highlighted the Paid Amount column after filtering out the November and December 2025 claims, the SUM function still added the $1 from each of those rows. The total came out as $5 instead of $3. The audit caught it. The user's trust in their own work was broken.
This is not a user error in the sense of carelessness. It is a design gap. Traditional spreadsheets were built for static tables, not dynamic analysis. Filters are a visual convenience, not a computational boundary. The user was doing exactly what the interface encouraged them to do, and the software silently betrayed them. For anyone running audits, reconciliations, or compliance checks, this kind of hidden behavior is dangerous. A long report with hundreds of rows hides the discrepancy. You only see it when someone else checks your work.
The practical fix is straightforward: use a function like SUMIF or SUMIFS that explicitly evaluates criteria, or convert the data into a proper table and use structured references. But the deeper point is about the tools we rely on. If your spreadsheet can hide data from your eyes but not from your formulas, it is not doing what you think it is doing. The user learned this the hard way, under audit pressure. The rest of us should learn it before the audit arrives. Do not trust what the filter shows. Trust what the formula is told to ignore.