Count between dates

[phitho]

Column A has dates for the past 5 years. Column B has numbers. I want to know how many numbers are between particular dates that I can specify.

Completely lost. Send help.

 

[AhoyNC]

Depending on your ver. of Excel:

Either COUNTIFS or SUMPRODUCT

Excel Workbook
	A	B	C	D	E
1	Date	Num		Start Date	2/25/2016
2	10/14/2014	1		End Date	4/5/2017
3	12/15/2014	2
4	1/2/2015	3		Count	5
5	2/5/2015	4			5
6	3/1/2016	5
7	4/5/2016	6
8	1/2/2017	7
9	1/23/2017	8
10	3/4/2017	9
11	5/1/2007	10
Sheet

 

[phitho]

So in place of numbers, what if I have a list of names, like John Doe, Mary Smith, Jack Clark? When I use a list of names it returns a 0.

 

[AhoyNC]

How about posting a small sample of your data and the result you want.
-Are you trying to count names between dates?
-Are the list of names unique or are there duplicates?
-Are your dates actual Excel dates or text?
-What ver. of Excel are you using?

 

[phitho]

Excel Office 365
Dates are Excel Dates
The names repeat as needed
The question is how many times does the name John Doe appear between 8/2/2017 and 8/4/2017...etc...

Column A Column B
8/1/2017 Joe Smith
8/2/2017 John Doe
8/3/2017 John Doe
8/4/2017 Joe Smith
8/5/2017 John Doe
8/2/2017 John Doe
8/3/2017 John Doe
8/4/2017 Joe Smith
8/5/2017 John Doe
8/2/2017 John Doe
8/3/2017 John Doe
8/4/2017 Joe Smith
8/5/2017 John Doe
8/2/2017 John Doe
8/3/2017 John Doe
8/4/2017 Joe Smith
8/5/2017 John Doe

 

[AhoyNC]

Use COUNTIFS.

Excel Workbook
	A	B	C	D	E
1	8/1/2017	Joe Smith		Start Date	8/2/2017
2	8/2/2017	John Doe		End Date	8/4/2017
3	8/3/2017	John Doe
4	8/4/2017	Joe Smith		Joe Smith	4
5	8/5/2017	John Doe		John Doe	8
6	8/2/2017	John Doe
7	8/3/2017	John Doe
8	8/4/2017	Joe Smith
9	8/5/2017	John Doe
10	8/2/2017	John Doe
11	8/3/2017	John Doe
12	8/4/2017	Joe Smith
13	8/5/2017	John Doe
14	8/2/2017	John Doe
15	8/3/2017	John Doe
16	8/4/2017	Joe Smith
17	8/5/2017	John Doe
Sheet