Count number of times each name is listed between certain dates

[HeRoseInThree]

UGH. OK, I would love to be able to count the number of times a name is displayed in a particular date range.

The names are listed in column B, all of the specific dates are in column H and the date range is AM1:AN26 (AM1 is 1/1/2018 and AN26 is 12/31/2019).

I will appreciate any help!!!

 

[hiker95]

HeRoseInThree,

To start off, and, so that we can get it right on the first try:

Can you post a screenshot of the actual raw data worksheet?

And, can you post a screenshot of the worksheet results (manually formatted by you) that you are looking for?

To post a small screen shot (NOT a graphic, or, picture, or, PNG file, or, flat text) try one of the following:

Click on the below link to see How to display your sheet, and, how to install, download, and, use the MrExcel HTML Maker: http://www.mrexcel.com/forum/board-a...uidelines.html


Or, it is always easier to help and test possible solutions if we could work with your actual file.

Perhaps you could upload a copy of your file to a free site such as www.box.com or www.dropbox.com.

Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here.

Include a detailed explanation of what you would like to do referring to specific cells and worksheets.

If the workbook contains confidential information, you could replace it with generic data.

 

[AhoyNC]

Maybe try COUNTIFS function.
Maybe this example will help. It is based on the first date range in AM1 to AN1.

Excel Workbook
	A	B	H	I	AL	AM	AN	AO	AP	AQ
1		Name	Date			1/1/2018	3/1/2018
2		Name1	1/2/2018			4/5/2018	10/31/2018		Name1	2
3		Name2	2/6/2018			2/19/2019	5/1/2019		Name2	1
4		Name1	2/4/2018			4/12/2019	7/5/2019		Name5	0
5		Name1	10/12/2018						Name6	0
6		Name5	5/6/2019						Name8	0
7		Name6	5/7/2019
8		Name6	5/8/2019
9		Name8	6/12/2019
Sheet

 

[HeRoseInThree]

=COUNTIFS(H$2:H$999999,">="&AM1,H$2:H$999999,"<="&AN1,B$2:B$999999,AC2)

where h2:h999999 are the dates in question
b2:b999999 are the names to be counted
ac2 is the name I'm trying to tally
am1:an26 is the date range[TABLE="width: 145"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD="align: right"]1/1/2018[/TD]
[TD="align: right"]1/31/2018[/TD]
[/TR]
[TR]
[TD="align: right"]2/1/2018[/TD]
[TD="align: right"]2/28/2018[/TD]
[/TR]
[TR]
[TD="align: right"]3/1/2018[/TD]
[TD="align: right"]3/31/2018[/TD]
[/TR]
[TR]
[TD="align: right"]4/1/2018[/TD]
[TD="align: right"]4/30/2018[/TD]
[/TR]
[TR]
[TD="align: right"]5/1/2018[/TD]
[TD="align: right"]5/31/2018[/TD]
[/TR]
[TR]
[TD="align: right"]6/1/2018[/TD]
[TD="align: right"]6/30/2018[/TD]
[/TR]
[TR]
[TD="align: right"]7/1/2018[/TD]
[TD="align: right"]7/31/2018[/TD]
[/TR]
[TR]
[TD="align: right"]8/1/2018[/TD]
[TD="align: right"]8/31/2018[/TD]
[/TR]
[TR]
[TD="align: right"]9/1/2018[/TD]
[TD="align: right"]9/30/2018[/TD]
[/TR]
[TR]
[TD="align: right"]10/1/2018[/TD]
[TD="align: right"]10/31/2018[/TD]
[/TR]
[TR]
[TD="align: right"]11/1/2018[/TD]
[TD="align: right"]11/30/2018[/TD]
[/TR]
[TR]
[TD="align: right"]12/1/2018[/TD]
[TD="align: right"]12/31/2018[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1/1/2019[/TD]
[TD="align: right"]1/31/2019[/TD]
[/TR]
[TR]
[TD="align: right"]2/1/2019[/TD]
[TD="align: right"]2/28/2019[/TD]
[/TR]
[TR]
[TD="align: right"]3/1/2019[/TD]
[TD="align: right"]3/31/2019[/TD]
[/TR]
[TR]
[TD="align: right"]4/1/2019[/TD]
[TD="align: right"]4/30/2019[/TD]
[/TR]
[TR]
[TD="align: right"]5/1/2019[/TD]
[TD="align: right"]5/31/2019[/TD]
[/TR]
[TR]
[TD="align: right"]6/1/2019[/TD]
[TD="align: right"]6/30/2019[/TD]
[/TR]
[TR]
[TD="align: right"]7/1/2019[/TD]
[TD="align: right"]7/31/2019[/TD]
[/TR]
[TR]
[TD="align: right"]8/1/2019[/TD]
[TD="align: right"]8/31/2019[/TD]
[/TR]
[TR]
[TD="align: right"]9/1/2019[/TD]
[TD="align: right"]9/30/2019[/TD]
[/TR]
[TR]
[TD="align: right"]10/1/2019[/TD]
[TD="align: right"]10/31/2019[/TD]
[/TR]
[TR]
[TD="align: right"]11/1/2019[/TD]
[TD="align: right"]11/30/2019[/TD]
[/TR]
[TR]
[TD="align: right"]12/1/2019[/TD]
[TD="align: right"]12/31/2019[/TD]
[/TR]
</tbody>[/TABLE]

 

[HeRoseInThree]

=COUNTIFS(H$2:H$999999,">="&AL2,H$2:H$999999,"<="&AM2,B$2:B$999999,AC$2)

GOT IT, Thanks!!!!!!

 

[AhoyNC]

You're welcome. Thanks for the feedback.