Counting rows by date or criteria is awkward
Counting or summing rows by date window, period or criteria needs complicated formulas that are easy to get wrong.
Tier I · Proven The best-established problems.
5 public reports · first reported 6 September 2018 · last reported 17 January 2025
What's going wrong
Users of Google Sheets need totals and counts for a rolling window, a quarter, a month, or matching criteria across several columns.
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 5 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.