Countifs results in 0 with Date range

I need some help with my formula. The data ranges in the formula is blocking the outcome. If the second and third criteria are removed then the formula works, but gives me a count for the year. A2 and B2 are the dates with in the sheet. Any help would be nice.

I've tried using Sumproduct as well with the same results. I've tried using dates with in the formula to no avail.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

For the countifs, the syntax to do >=CellRef is
">="&A2

Try
=COUNTIFS('Sheet1'!G:G, "Keyword", 'Sheet1'!F:F,"<="&A2, 'Sheet1'!F:F, ">="&B2)

Dates are 2013-11-7 format displaying in long form. I tried doing a few tests with limited data and came up with the same results. I've added a URL to my test file if you want to take a look. I thought that I was missing something in my formula.


https://dl.dropboxusercontent.com/u/18658364/Book1.xlsx

Some of your dates are not really dates, they're just text strings.

The dates in D3 D5 E3 and F14 are all real dates.
The rest are just text strings.

Correct the dates in E5 and F15 through F18


And use the formula like this in G3
=COUNTIFS($G$14:$G$18,"Expenses",$F$14:$F$18,"<="&E3, $F$14:$F$18, ">="&D3)

So the dates were the issue, and the sumproduct works as well.

Thanks everyone!

You're welcome.