Count of text in a column based off a date range in another column

[hofst038]

Really needs some help on this: I am trying to get a count of something that is in a given date range.

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. Can someone please help me out?

 

[Joe4]

I forgot to mention, the dates it is looking up is pulled in via V lookup from another file... could this possibly be part of the problem?

Not if they are really dates.

Please answer the questions I posted in my previous reply. Note that in your duplicate post, it looks like you were including your title row (row 1) in your date range. You don't want to do that. The formula should just reference the data that you are checking.

 

[hofst038]

Sorry for opening another thread, thought since we came to a resolution this thread was closed. Beginners mistake. Also, I figured it out, Im a moron.... wrong digit in the wrong place. Thanks for all the hlep

 

[Joe4]

Threads never really get officially "closed" here. If you still have questions on it, it is not resolved, so feel free to keep posting to the original thread.
You would only start a new thread if it was a new question that is not directly related or dependent upon the original question.