Countifs formula is not working correctly

[hofst038]

[TABLE="class: cms_table"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Lead Tech[/TD]
[TD]Non Lead Tech[/TD]
[TD]Completed[/TD]
[/TR]
[TR]
[TD]3/11/2016[/TD]
[TD][/TD]
[TD][/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD]3/15/2016[/TD]
[TD][/TD]
[TD][/TD]
[TD]N[/TD]
[/TR]
[TR]
[TD]3/16/2016[/TD]
[TD][/TD]
[TD][/TD]
[TD]N[/TD]
[/TR]
[TR]
[TD]3/17/2016[/TD]
[TD][/TD]
[TD][/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD]3/20/2016[/TD]
[TD][/TD]
[TD][/TD]
[TD]N[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


So I want a count of all the “Y” values in the Completed column based off the date range of 3/11/2016-3/18/2016.

My formula goes like this: =COUNTIFS($A$1:$A$6, ">=" &DATEVALUE("3/11/2016"),$A$1:$A$6, "<="&DATEVALUE("3/18/2106"),$D$1:$D$6, "Y")

It seems to be ignoring the formula and grabbing ALL dates that are 3/11/2016 and above, not just the ones in the selected date range 3/11/2016-3/18/2016. Does anyone know how to fix this so it grabs only the dates from 3/11/2016 to 3/18/2016?

 

[dave3009]

Did you mean to set the second date as 2106?

 

[Joe4]

Duplicate: http://www.mrexcel.com/forum/excel-...lumn-based-off-date-range-another-column.html

Please do not post the same question multiple times. All clarifications, directly-related follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #12 here: Forum Rules).

Not sure why you did that anyway, since we are helping you out on that thread!