Date | Lead Tech | Non Lead Tech | Completed |
3/11/2016 | Y | ||
3/15/2016 | N | ||
3/16/2016 | N | ||
3/17/2016 | Y | ||
3/20/2016 | N | ||
<tbody>
</tbody>
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?