Conditional counts and sums across dates are error-prone
Counting or summing rows that meet several conditions, such as a date window or month plus a flag, needs formulas that are hard to get right.
Tier I · Proven The best-established problems.
6 public reports · first reported 6 September 2018 · last reported 17 January 2025
What's going wrong
People counting or summing spreadsheet rows often need to match more than one condition at once, such as a value in one column, a month taken from a date, or a date between two limits.
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 6 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.