Category and month totals come out wrong
Conditional sums and counts by category, month, or partial text give wrong totals when criteria come from other cells.
Tier II · Emerging Problems that are still building up.
7 public reports · first reported 9 January 2020 · last reported 15 August 2024
What's going wrong
People summarizing expenses, product lines, or partner data report that SUMIFS, COUNTIFS, and QUERY sums give wrong totals when the criteria come from a cell or use wildcards.
AI-assisted: written with the help of AI from the reports. The idea report has the full summary.
In the idea report
- The full summary.
- The products the 7 reports are about, and how many came each month.
- Related problems.
No business has been found with this problem yet, so the report has no contacts. All sales are final — no refunds. Pricing.