How to total unique values in one column between dates in another column?

[wmichael]

Hello. Asking your help to total unique values in column CV between dates of 7/1/2019 and 7/31/2019 in column DF. Thank you in advance for your help with this.

2019-22 Media Clips v06.xlsx
	CU	CV	CW	CX	CY	CZ	DA	DB	DC	DD	DE	DF
1	171 Headlines	Distributed by 167 Outlets	Across 1 Direct Media Areas	Dma Rank	Across 135 Cities	and 34 States	and 1 Countries	Produced a combined total of 105,537,593 Circulation, Impressions, and Event Attendees	With a total of $6,124,953 in Media Value	Consisting of 57 Print Articles, 285 Web Headlines, and Attendees to 0 Events that breaks down to:	Published Date	Posted Date
2	Englewood Community News Briefs for July 2, 2019	Sun Newspapers	N/A	N/A	ENGLEWOOD	FL	USA	21,268	$485	- Web	07-01-2019	7/3/2019
3	Promoting safe boating	SMITH MOUNTAIN EAGLE	N/A	68	MONETA	VA	USA	4,400	$166	- Print	06-26-2019	7/10/2019
4	Root Beer Floats", but you don't, so wear your life jacket	BEDFORD BULLETIN	N/A	68	BEDFORD	VA	USA	4,563	$276	- Print	06-26-2019	7/10/2019
5	New life jacket loaner stands open in Norwalk - The Register Citizen	Register Citizen	N/A	N/A	TORRINGTON	CT	USA	17,253	$364	- Web	07-12-2019	7/18/2019
6	New life jacket loaner stands open in Norwalk	Connecticut Post	N/A	N/A	BRIDGEPORT	CT	USA	394,799	$13,453	- Web	07-12-2019	7/18/2019
7	New life jacket loaner stands open in Norwalk	Middletown Press	N/A	N/A	MIDDLETOWN	CT	USA	11,272	$95	- Web	07-12-2019	7/18/2019
8	'ABCs' are important in drowning prevention	Fort Myers Beach Observer	N/A	N/A	FORT MYERS	FL	USA	3,738	$1,205	- Web	07-19-2019	7/24/2019
9	Water safety: 'ABCs' are important in drowning prevention	Island Reporter	N/A	N/A	SANIBEL	FL	USA	507	$9,563	- Web	07-19-2019	7/24/2019
10	Water safety: 'ABCs' are important in drowning prevention	Cape Coral Daily Breeze	N/A	N/A	CAPE CORAL	FL	USA	2,878	$32	- Web	07-18-2019	7/24/2019
11	Wake the World returns to Crazy Horse Marina	ROANOKE TIMES	N/A	68	ROANOKE	VA	USA	35,946	$1,159	- Print	07-31-2019	8/1/2019
12	Ten tips to make boating with children safe, fun	FLORIDA WEEKLY	N/A	N/A	FORT MYERS	FL	USA	18,242	$400	- Print	07-30-2019	8/7/2019
13	Sea Tow Foundation Receives US Coast Guard Grants	Marina Dock Age	N/A	N/A	NILES	IL	USA	8,500	$447	- Web	08-05-2019	8/9/2019
14	Sea Tow Foundation to present safety awards at Boating Industry's Elevate - Boating Industry	Boating Industry Online	N/A	N/A	MAPLE GROVE	MN	USA	9,758	$75	- Web	08-15-2019	8/15/2019
15	Sea Tow Foundation launches new awards - Trade Only Today	Soundings: Trade Only	N/A	N/A	ESSEX	CT	USA	12,219	$97	- Web	08-15-2019	8/19/2019
16	Sea Tow Foundation Extends Deadline for Boating Industry Safety Awards	Fishing Wire (The)	N/A	N/A	GLEN ALLEN	VA	USA	2,946	$29	- Web	09-24-2019	9/30/2019
17	Coast Guard Awards Grants to Sea Tow Foundation Programs	LAKELAND BOATING	N/A	N/A	EVANSTON	IL	USA	42,096	$642	- Print	10-01-2019	10/21/2019
18	Sea Tow Foundation Announces National Boating Industry Safety Award Winners	Public	N/A	N/A	NEW YORK	NY	USA	18,219	$63	- Web	12-04-2019	12/4/2019
19	Sea Ray and Freedom Boat Club win National Safety Awards	Count on 2 First	N/A	N/A	NAPLES	FL	USA	69,903	$1,052	- Web	12-02-2019	12/4/2019
20	Downriver communities wrap up year	Voice (The)	N/A	N/A	NEW BALTIMORE	MI	USA	2,510	$152	- Web	12-19-2019	12/23/2019
21	Hartford Boat Show returns to Mohegan Sun - New Haven Register	New Haven Register	N/A	N/A	NEW HAVEN	CT	USA	111,844	$3,581	- Web	01-08-2020	1/9/2020
22	With Flying Colors - Soundings Online	Soundings	N/A	N/A	ESSEX	CT	USA	21,182	$348	- Web	01-15-2020	1/16/2020
23	Enhance Your Customers' Boating Experience with Peace of Mind on the Water	SOUNDINGS (TRADE ONLY)	N/A	N/A	ESSEX	CT	USA	27,272	$2,718	- Print	04-01-2020	3/31/2020
24	Sea Tow Foundation Launches New Website	Outdoor Wire (The)	N/A	N/A	GLEN ALLEN	VA	USA	520	$22	- Web	04-03-2020	4/6/2020
25	Mom Honors Her Late Son With Hernando Beach Life Jacket Loaner Station	Spectrum Bay News 9	N/A	N/A	TAMPA	FL	USA	230,161	$2,621	- Web	05-17-2020	5/18/2020
26	10 tips for boating with kids by Safe Kids, Heather O'Brien	SWFL Parent & Child	N/A	N/A	FORT MYERS	FL	USA	8,500	$934	- Web	07-02-2019	7/3/2019
27	Lake Shelbyville to hold Life Jacket Drive	Shelbyville Daily Union (The)	N/A	N/A	SHELBYVILLE	IL	USA	4,579	$88	- Web	06-27-2019	7/3/2019
28	Where to find loaner life jackets in SW FL by Safe Kids	SWFL Parent & Child	N/A	N/A	FORT MYERS	FL	USA	8,500	$404	- Web	07-02-2019	7/3/2019
29	EYE ON THE BALL	SHELTER ISLAND REPORTER	N/A	1	SHELTER ISLAND	NY	USA	2,927	$190	- Print	06-20-2019	7/5/2019
30	Englewood Briefs for July 10, 2019	Sun Newspapers	N/A	N/A	ENGLEWOOD	FL	USA	21,268	$931	- Web	07-09-2019	7/10/2019
31	Community Briefs for July 14, 2019	Sun Newspapers	N/A	N/A	ENGLEWOOD	FL	USA	21,268	$834	- Web	07-12-2019	7/18/2019
32	Englewood Community Briefs for July 12, 2019	Sun Newspapers	N/A	N/A	ENGLEWOOD	FL	USA	21,268	$914	- Web	07-11-2019	7/18/2019
33	Water safety: 'ABCs' are important in drowning prevention	Pine Island Eagle	N/A	N/A	BOKEELIA	FL	USA	1,413	$31	- Web	07-18-2019	7/24/2019
34	Escape the heat by taking a swim a " but don't forget the life jacket	Williamsburg Yorktown Daily	N/A	N/A	WILLIAMSBURG	VA	USA	4,897	$87	- Web	07-22-2019	7/24/2019
35	Water safety: 'ABCs' are important in drowning prevention	Fort Myers Beach Observer	N/A	N/A	FORT MYERS	FL	USA	3,738	$1,190	- Web	07-19-2019	7/24/2019
36	Escape the heat by taking a swim a " but don't forget the life jacket	Williamsburg Yorktown Daily	N/A	N/A	WILLIAMSBURG	VA	USA	4,897	$87	- Web	07-22-2019	7/30/2019
37	Life Jacket, Sober Skipper Programs to Receive USCG Grant Funding	Boating World	N/A	N/A	ATLANTA	GA	USA	760	$15	- Web	08-01-2019	8/5/2019
38	Life jacket pre tips for boating season	FLORIDA WEEKLY	N/A	N/A	FORT MYERS	FL	USA	18,242	$126	- Print	07-30-2019	8/7/2019
39	Englewood Community Briefs for Aug, 7, 2019	Sun Newspapers	N/A	N/A	ENGLEWOOD	FL	USA	21,268	$484	- Web	08-06-2019	8/9/2019
raw

Cell Formulas
Range	Formula
CU1	CU1	=CONCATENATE(SUM(IF(FREQUENCY(IF(LEN(CU2:CU492)>0,MATCH(CU2:CU492,CU2:CU492,0),""),IF(LEN(CU2:CU492)>0,MATCH(CU2:CU492,CU2:CU492,0),""))>0,1))," Headlines")
CV1	CV1	=CONCATENATE("Distributed by ",SUM(IF(FREQUENCY(IF(LEN(CV2:CV492)>0,MATCH(CV2:CV492,CV2:CV492,0),""),IF(LEN(CV2:CV492)>0,MATCH(CV2:CV492,CV2:CV492,0),""))>0,1))," Outlets")
CW1	CW1	=CONCATENATE("Across ",SUM(IF(FREQUENCY(IF(LEN(CW2:CW492)>0,MATCH(CW2:CW492,CW2:CW492,0),""),IF(LEN(CW2:CW492)>0,MATCH(CW2:CW492,CW2:CW492,0),""))>0,1))," Direct Media Areas")
CY1	CY1	=CONCATENATE("Across ",SUM(IF(FREQUENCY(IF(LEN(CY2:CY492)>0,MATCH(CY2:CY492,CY2:CY492,0),""),IF(LEN(CY2:CY492)>0,MATCH(CY2:CY492,CY2:CY492,0),""))>0,1))," Cities")
CZ1	CZ1	=CONCATENATE("and ",SUM(IF(FREQUENCY(IF(LEN(CZ2:CZ492)>0,MATCH(CZ2:CZ492,CZ2:CZ492,0),""),IF(LEN(CZ2:CZ492)>0,MATCH(CZ2:CZ492,CZ2:CZ492,0),""))>0,1))," States")
DA1	DA1	=CONCATENATE("and ",SUM(IF(FREQUENCY(IF(LEN(DA2:DA492)>0,MATCH(DA2:DA492,DA2:DA492,0),""),IF(LEN(DA2:DA492)>0,MATCH(DA2:DA492,DA2:DA492,0),""))>0,1))," Countries")
DB1	DB1	=CONCATENATE("Produced a combined total of ",TEXT(SUM(DB2:DB492),"#,##0")," Circulation, Impressions, and Event Attendees")
DC1	DC1	=CONCATENATE("With a total of $",TEXT(SUM(DC2:DC492),"#,##0")," in Media Value")
DD1	DD1	=CONCATENATE("Consisting of ",COUNTIF(DD2:DD492,"*Print*")," Print Articles, ",COUNTIF(DD2:DD492,"*Web*")," Web Headlines, and Attendees to ",COUNTIF(DD2:DD492,"*Event*")," Events that breaks down to:")

 

[AhoyNC]

Try:

Book4
	CS	CT	CU	CV									DE	DF
1			33 Headlines	Distributed by 30 Outlets									Published Date	Posted Date
2	Excel 365		Englewood Community News Briefs for July 2, 2019	Sun Newspapers									7/1/2019	7/3/2019
3	14		Promoting safe boating	SMITH MOUNTAIN EAGLE									6/26/2019	7/10/2019
4	Excel 2019 or 2007		Root Beer Floats", but you don't, so wear your life jacket	BEDFORD BULLETIN									6/26/2019	7/10/2019
5	14		New life jacket loaner stands open in Norwalk - The Register Citizen	Register Citizen									7/12/2019	7/18/2019
6			New life jacket loaner stands open in Norwalk	Connecticut Post									7/12/2019	7/18/2019
7			New life jacket loaner stands open in Norwalk	Middletown Press									7/12/2019	7/18/2019
8			'ABCs' are important in drowning prevention	Fort Myers Beach Observer									7/19/2019	7/24/2019
9			Water safety: 'ABCs' are important in drowning prevention	Island Reporter									7/19/2019	7/24/2019
10			Water safety: 'ABCs' are important in drowning prevention	Cape Coral Daily Breeze									7/18/2019	7/24/2019
11			Wake the World returns to Crazy Horse Marina	ROANOKE TIMES									7/31/2019	8/1/2019
12			Ten tips to make boating with children safe, fun	FLORIDA WEEKLY									7/30/2019	8/7/2019
13			Sea Tow Foundation Receives US Coast Guard Grants	Marina Dock Age									8/5/2019	8/9/2019
14			Sea Tow Foundation to present safety awards at Boating Industry's Elevate - Boating Industry	Boating Industry Online									8/15/2019	8/15/2019
15			Sea Tow Foundation launches new awards - Trade Only Today	Soundings: Trade Only									8/15/2019	8/19/2019
16			Sea Tow Foundation Extends Deadline for Boating Industry Safety Awards	Fishing Wire (The)									9/24/2019	9/30/2019
17			Coast Guard Awards Grants to Sea Tow Foundation Programs	LAKELAND BOATING									10/1/2019	10/21/2019
18			Sea Tow Foundation Announces National Boating Industry Safety Award Winners	Public									12/4/2019	12/4/2019
19			Sea Ray and Freedom Boat Club win National Safety Awards	Count on 2 First									12/2/2019	12/4/2019
20			Downriver communities wrap up year	Voice (The)									12/19/2019	12/23/2019
21			Hartford Boat Show returns to Mohegan Sun - New Haven Register	New Haven Register									1/8/2020	1/9/2020
22			With Flying Colors - Soundings Online	Soundings									1/15/2020	1/16/2020
23			Enhance Your Customers' Boating Experience with Peace of Mind on the Water	SOUNDINGS (TRADE ONLY)									4/1/2020	3/31/2020
24			Sea Tow Foundation Launches New Website	Outdoor Wire (The)									4/3/2020	4/6/2020
25			Mom Honors Her Late Son With Hernando Beach Life Jacket Loaner Station	Spectrum Bay News 9									5/17/2020	5/18/2020
26			10 tips for boating with kids by Safe Kids, Heather O'Brien	SWFL Parent & Child									7/2/2019	7/3/2019
27			Lake Shelbyville to hold Life Jacket Drive	Shelbyville Daily Union (The)									6/27/2019	7/3/2019
28			Where to find loaner life jackets in SW FL by Safe Kids	SWFL Parent & Child									7/2/2019	7/3/2019
29			EYE ON THE BALL	SHELTER ISLAND REPORTER									6/20/2019	7/5/2019
30			Englewood Briefs for July 10, 2019	Sun Newspapers									7/9/2019	7/10/2019
31			Community Briefs for July 14, 2019	Sun Newspapers									7/12/2019	7/18/2019
32			Englewood Community Briefs for July 12, 2019	Sun Newspapers									7/11/2019	7/18/2019
33			Water safety: 'ABCs' are important in drowning prevention	Pine Island Eagle									7/18/2019	7/24/2019
34			Escape the heat by taking a swim a " but don't forget the life jacket	Williamsburg Yorktown Daily									7/22/2019	7/24/2019
35			Water safety: 'ABCs' are important in drowning prevention	Fort Myers Beach Observer									7/19/2019	7/24/2019
36			Escape the heat by taking a swim a " but don't forget the life jacket	Williamsburg Yorktown Daily									7/22/2019	7/30/2019
37			Life Jacket, Sober Skipper Programs to Receive USCG Grant Funding	Boating World									8/1/2019	8/5/2019
38			Life jacket pre tips for boating season	FLORIDA WEEKLY									7/30/2019	8/7/2019
39			Englewood Community Briefs for Aug, 7, 2019	Sun Newspapers									8/6/2019	8/9/2019
Sheet1

Cell Formulas
Range	Formula
CU1	CU1	=CONCATENATE(SUM(IF(FREQUENCY(IF(LEN(CU2:CU492)>0,MATCH(CU2:CU492,CU2:CU492,0),""),IF(LEN(CU2:CU492)>0,MATCH(CU2:CU492,CU2:CU492,0),""))>0,1))," Headlines")
CV1	CV1	=CONCATENATE("Distributed by ",SUM(IF(FREQUENCY(IF(LEN(CV2:CV492)>0,MATCH(CV2:CV492,CV2:CV492,0),""),IF(LEN(CV2:CV492)>0,MATCH(CV2:CV492,CV2:CV492,0),""))>0,1))," Outlets")
CS3	CS3	=COUNTA(UNIQUE(FILTER($CV$2:$CV$39,($DF$2:$DF$39>=DATE(2019,7,1))*($DF$2:$DF$39<=DATE(2019,7,31)),"")))
CS5	CS5	=SUM(IF(FREQUENCY(IF($DF$2:$DF$39>=DATE(2019,7,1),IF($DF$2:$DF$39<=DATE(2019,7,31),MATCH($CV$2:$CV$39,$CV$2:$CV$39,0))),ROW($CV$2:$CV$39)-ROW($CV$2)+1),1))