Using the COUNTIFS function in Excel with Date Ranges

Question

I'm using the CountIFS function with four criteria, but two are date ranges.

I've used three criteria (Count of X in some column where Date in another column >1/1/2025 and Date in that second column < 2/1/2025) criteria with success, but when I did one with a fourth criteria, I get back zeroes.

=COUNTIFS('DETAILS'!$M$2:$M$5000, "Chewing Gum",'DETAILS'!$L$2:$L$5000, "Cinnamon",'DETAILS'!$B$2:$B$5000, ">7/11/2025",'DETAILS'!$B$2:$B$5000, "<8/11/2025")

Any help would be greatly appreciated! (My fear is it is a typo, but it works with just one date rather than a range.)

Answer 1

The formula looks OK - assuming that you use US date format MDY. Are you absolutely sure that there are rows that match all four conditions?

If possible, could you create a stripped-down copy of the workbook demonstrating the problem (without sensitive information) and make it available through one of the websites that let you upload and share a file, such as OneDrive, Google Drive, FileDropper or DropBox. Then post a link to the uploaded and shared file here.

Answer 2

I figured it out - and it had to do with the format of the date column on that particular tab.