
Excel Functions & Formulas
How to Use COUNTIFS with Date Range and Text in Excel
Learn how to use COUNTIFS in Excel to filter by date range and text, match partial text, count specific months, & apply dynamic date filters.
Read article
3 lessons in order

Learn how to use COUNTIFS in Excel to filter by date range and text, match partial text, count specific months, & apply dynamic date filters.

Learn advanced Excel COUNTIFS techniques to count data by date ranges, partial matches, OR logic, exclusions, and structured references.
![[Fixed] COUNTIFS Not Working in Excel (6 Possible Solutions)](https://pub-b39c974f4c124a36a2fb517be38076ec.r2.dev/images/2026/08/featured-image-countifs-not-working-f659df3a.webp)
Learn why your COUNTIFS formula isn’t working in Excel and how to fix common issues like range mismatches, text criteria, and wildcards.