Count number of times each name is listed between certain dates

HeRoseInThree

Board Regular
Joined
Jan 11, 2018
Messages
103
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!!!
 

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.
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.
 
Last edited:
Upvote 0
Maybe try COUNTIFS function.
Maybe this example will help. It is based on the first date range in AM1 to AN1.
Excel Workbook
ABHIALAMANAOAPAQ
1NameDate1/1/20183/1/2018
2Name11/2/20184/5/201810/31/2018Name12
3Name22/6/20182/19/20195/1/2019Name21
4Name12/4/20184/12/20197/5/2019Name50
5Name110/12/2018Name60
6Name55/6/2019Name80
7Name65/7/2019
8Name65/8/2019
9Name86/12/2019
Sheet
 
Upvote 0
=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
1/1/20181/31/2018
2/1/20182/28/2018
3/1/20183/31/2018
4/1/20184/30/2018
5/1/20185/31/2018
6/1/20186/30/2018
7/1/20187/31/2018
8/1/20188/31/2018
9/1/20189/30/2018
10/1/201810/31/2018
11/1/201811/30/2018
12/1/201812/31/2018
1/1/20191/31/2019
2/1/20192/28/2019
3/1/20193/31/2019
4/1/20194/30/2019
5/1/20195/31/2019
6/1/20196/30/2019
7/1/20197/31/2019
8/1/20198/31/2019
9/1/20199/30/2019
10/1/201910/31/2019
11/1/201911/30/2019
12/1/201912/31/2019

<colgroup><col><col></colgroup><tbody>
</tbody>
 
Upvote 0
You're welcome. Thanks for the feedback.
 
Upvote 0

Forum statistics

Threads
1,213,489
Messages
6,113,949
Members
448,534
Latest member
benefuexx

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top