| 公式 | Use |
|---|---|
=SUMIFS(总和, 暴击范围, 暴击, ...) | 按类别和月份划分的预算实际情况 |
=INDEX(返回, MATCH(键, 查找, 0)) | 仍然是可靠的查找 |
=IFERROR(x, "") | 干净的仪表板 |
=TEXT(日期, "yyyy-mm") | 稳定的月份键 |
=XLOOKUP(...) | 在重写工作簿之前测试您的构建 |
=UNIQUE / =FILTER | 同样的警告 — 365 时代的功能有所不同 |
始终在单元格中设置已知良好的总数并进行比较。 AI 建议的公式是草稿。
模式，而不是琐事
=SUMIFS(Amount, Category, $G2, Month, H$1) is a dashboard. Copy it across a grid of categories × months. If #VALUE, Amount has text. If zeros everywhere, Month in the sheet is “Jan” and the header is “2026-01” — keys must match. =IFERROR(INDEX(... MATCH(...,0)), "") hides #不适用 for humans but also hides real misses — keep a count of unmatched keys somewhere visible.
易失性函数
现在、今天、兰德、偏移、间接重新计算经常。一张满是它们的纸在一台薄弱的电脑上会结结巴巴。更喜欢索引和有界范围。今天打印一次发票就可以了；今天在 50,000 行中则不然。
审核您未构建的工作表
查找 all formulas: jump to special if offered, or click cells that look like totals and read the formula bar. Trace a known-good number backwards. If you see #参考！, someone deleted a source. If you see numbers typed over formulas, the sheet is already a lie — copy values to an archive and rebuild Month.