How to count all the headlines listed in column CT between dates of July 1 and July 31 2019 listed in column CT

[wmichael]

Hello. Asking for your help to create a formula to count all the items listed in column CT between dates of July 1 and July 31 2019 listed in column DE in this example. Thank you in advance for your help.

2019-22 Media Clips v06.xlsx
	CT	CU	CV	CW	CX	CY	CZ	DA	DB	DC	DD	DE
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
raw

Cell Formulas
Range	Formula
CT1	CT1	=CONCATENATE(SUM(IF(FREQUENCY(IF(LEN(CT2:CT492)>0,MATCH(CT2:CT492,CT2:CT492,0),""),IF(LEN(CT2:CT492)>0,MATCH(CT2:CT492,CT2:CT492,0),""))>0,1))," Headlines")
CU1	CU1	=CONCATENATE("Distributed by ",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))," Outlets")
CV1	CV1	=CONCATENATE("Across ",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))," Direct Media Areas")
CX1	CX1	=CONCATENATE("Across ",SUM(IF(FREQUENCY(IF(LEN(CX2:CX492)>0,MATCH(CX2:CX492,CX2:CX492,0),""),IF(LEN(CX2:CX492)>0,MATCH(CX2:CX492,CX2:CX492,0),""))>0,1))," Cities")
CY1	CY1	=CONCATENATE("and ",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))," States")
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))," Countries")
DA1	DA1	=CONCATENATE("Produced a combined total of ",TEXT(SUM(DA2:DA492),"#,##0")," Circulation, Impressions, and Event Attendees")
DB1	DB1	=CONCATENATE("With a total of $",TEXT(SUM(DB2:DB492),"#,##0")," in Media Value")
DC1	DC1	=CONCATENATE("Consisting of ",COUNTIF(DC2:DC492,"*Print*")," Print Articles, ",COUNTIF(DC2:DC492,"*Web*")," Web Headlines, and Attendees to ",COUNTIF(DC2:DC492,"*Event*")," Events that breaks down to:")

 

[Candyman8019]

Give this a try: =COUNTIFS(CT:CT,">="&DATE(2019,7,1),CT:CT,"<="&DATE(2019,7,31))

 

[wmichael]

Give this a try: =COUNTIFS(CT:CT,">="&DATE(2019,7,1),CT:CT,"<="&DATE(2019,7,31))

Hello, I entered incorrect information in the headline and there is no way to go back and correct it - the question I am asking is How to count all the headlines listed in column CT between dates of July 1 and July 31 2019 listed in column DE

 

[Candyman8019]

=COUNTIFS(DE:DE,">=7/1/2019",DE:DE,"<=7/31/2019")

 

[wmichael]

=COUNTIFS(DE:DE,">=7/1/2019",DE:DE,"<=7/31/2019")

Sorry for the confusion but I am trying to count the headlines listed in CT between July 1, 2019 and July 31, 2019 in DE

 

[Fluff]

Have you actually tried the formula?

 

[wmichael]

Have you actually tried the formula?

Correct. I cannot make the formula count the headlines in column CT based on dates in column DE in the XL2BB example in the thread

 

[Fluff]

In what way doesn't it work?

 

[Candyman8019]

Regardless of what is in CT, what you're asking is how many values in DE are between the two dates. That is precisely what this formula does.

 

[wmichael]

Hello. I was able to get the formula to work- Thank you! Here is how it is applied:

2019-22 Media Clips v06.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U
2	SUMMARY	31	31	30	31	30	31	31	29	31	30	31	30	31	31	30	31	30	31	31	28
3	171 Headlines generated 342 Total Articles	20	28	11	12	6	76	25	6	3	15	9	7	29	4	67	6	5	13	-
4	Distributed by 167 Outlets
5	Across 135 Cities
6	and 34 States
7	Produced a combined total of 105,537,593 Circulation, Impressions, and Event Attendees	563,933
8	With a total of $6,124,953 in Media Value	$ 31,329.0
9	Consisting of 57 Print Articles, 285 Web Headlines, and Attendees to 0 Events that breaks down to:
10	1,700,783 Print Circulation	11,890
11	$103,323 Print Value	$ 632.0
12	103,836,810 Web Impressions	552,043
13	$6,021,630 Web Value	$ 30,697.0
14	0 Event Attendees
15	78,923,582 Impressions that Include Our Sponsors & Friends	10,816
16	Sponsor & Friends Impressions Valued at $2,159,093	$ 8,536.0
17	22,289,851 Impressions for Campaigns & General Content	105,462
18	Campaigns & General Content Impressions Valued at $578,945	$ 4,730.0
dashboard

Cell Formulas
Range	Formula
B3	B3	=COUNTIFS(raw!$DF2:$DF1000,">=7/1/2019",raw!$DF2:$DF$1000,"<=7/31/2019")
C3	C3	=COUNTIFS(raw!$DF2:$DF1000,">=8/1/2019",raw!$DF2:$DF$1000,"<=8/31/2019")
D3	D3	=COUNTIFS(raw!$DF2:$DF1000,">=9/1/2019",raw!$DF2:$DF$1000,"<=9/30/2019")
E3	E3	=COUNTIFS(raw!$DF2:$DF1000,">=10/1/2019",raw!$DF2:$DF$1000,"<=10/31/2019")
F3	F3	=COUNTIFS(raw!$DF2:$DF1000,">=11/1/2019",raw!$DF2:$DF$1000,"<=11/30/2019")
G3	G3	=COUNTIFS(raw!$DF2:$DF1000,">=12/1/2019",raw!$DF2:$DF$1000,"<=12/31/2019")
H3	H3	=COUNTIFS(raw!$DF2:$DF1000,">=1/1/2020",raw!$DF2:$DF$1000,"<=1/31/2020")
I3	I3	=COUNTIFS(raw!$DF2:$DF1000,">=2/1/2020",raw!$DF2:$DF$1000,"<=2/29/2020")
J3	J3	=COUNTIFS(raw!$DF2:$DF1000,">=3/1/2020",raw!$DF2:$DF$1000,"<=3/31/2020")
K3	K3	=COUNTIFS(raw!$DF2:$DF1000,">=4/1/2020",raw!$DF2:$DF$1000,"<=4/30/2020")
L3	L3	=COUNTIFS(raw!$DF2:$DF1000,">=5/1/2020",raw!$DF2:$DF$1000,"<=5/31/2020")
M3	M3	=COUNTIFS(raw!$DF2:$DF1000,">=6/1/2020",raw!$DF2:$DF$1000,"<=6/30/2020")
N3	N3	=COUNTIFS(raw!$DF2:$DF1000,">=7/1/2020",raw!$DF2:$DF$1000,"<=7/31/2020")
O3	O3	=COUNTIFS(raw!$DF2:$DF1000,">=8/1/2020",raw!$DF2:$DF$1000,"<=8/31/2020")
P3	P3	=COUNTIFS(raw!$DF2:$DF1000,">=9/1/2020",raw!$DF2:$DF$1000,"<=9/30/2020")
Q3	Q3	=COUNTIFS(raw!$DF2:$DF1000,">=10/1/2020",raw!$DF2:$DF$1000,"<=10/31/2020")
R3	R3	=COUNTIFS(raw!$DF2:$DF1000,">=11/1/2020",raw!$DF2:$DF$1000,"<=11/30/2020")
S3	S3	=COUNTIFS(raw!$DF2:$DF1000,">=12/1/2020",raw!$DF2:$DF$1000,"<=12/31/2020")
T3	T3	=COUNTIFS(raw!$DF2:$DF1000,">=1/1/2021",raw!$DF2:$DF$1000,"<=1/31/2021")
B7	B7	=SUMIFS(raw!$DB$2:$DB$980,raw!$DF$2:$DF$980,">"&DATEVALUE("7/1/2019"),raw!$DF$2:$DF$980,"<"&DATEVALUE("7/31/2019"))
B8	B8	=SUMIFS(raw!$DC$2:$DC$980,raw!$DF$2:$DF$980,">"&DATEVALUE("7/1/2019"),raw!$DF$2:$DF$980,"<"&DATEVALUE("7/31/2019"))
B10	B10	=SUMIFS(raw!$DH$2:$DH$980,raw!$DF$2:$DF$980,">"&DATEVALUE("7/1/2019"),raw!$DF$2:$DF$980,"<"&DATEVALUE("7/31/2019"))
B11	B11	=SUMIFS(raw!$DI$2:$DI$980,raw!$DF$2:$DF$980,">"&DATEVALUE("7/1/2019"),raw!$DF$2:$DF$980,"<"&DATEVALUE("7/31/2019"))
B12	B12	=SUMIFS(raw!$DJ$2:$DJ$980,raw!$DF$2:$DF$980,">"&DATEVALUE("7/1/2019"),raw!$DF$2:$DF$980,"<"&DATEVALUE("7/31/2019"))
B13	B13	=SUMIFS(raw!$DK$2:$DK$980,raw!$DF$2:$DF$980,">"&DATEVALUE("7/1/2019"),raw!$DF$2:$DF$980,"<"&DATEVALUE("7/31/2019"))
A3	A3	=CONCATENATE(raw!CU1," generated ",raw!CQ1)
A4	A4	=raw!CV1
A5	A5	=raw!CY1
A6	A6	=raw!CZ1
A7	A7	=raw!DB1
A8	A8	=raw!DC1
A9	A9	=raw!DD1
A10	A10	=raw!DH1
A11	A11	=raw!DI1
A12	A12	=raw!DJ1
A13	A13	=raw!DK1
A14	A14	=raw!DL1
A15	A15	=raw!BH1
B15	B15	=SUMIFS(raw!$BI$2:$BI$980,raw!$DF$2:$DF$980,">"&DATEVALUE("7/1/2019"),raw!$DF$2:$DF$980,"<"&DATEVALUE("7/31/2019"))
A16	A16	=raw!BI1
B16	B16	=SUMIFS(raw!$BH$2:$BH$980,raw!$DF$2:$DF$980,">"&DATEVALUE("7/1/2019"),raw!$DF$2:$DF$980,"<"&DATEVALUE("7/31/2019"))
A17	A17	=raw!BW1
B17	B17	=SUMIFS(raw!$BW$2:$BW$980,raw!$DF$2:$DF$980,">"&DATEVALUE("7/1/2019"),raw!$DF$2:$DF$980,"<"&DATEVALUE("7/31/2019"))
A18	A18	=raw!BX1
B18	B18	=SUMIFS(raw!$BX$2:$BX$980,raw!$DF$2:$DF$980,">"&DATEVALUE("7/1/2019"),raw!$DF$2:$DF$980,"<"&DATEVALUE("7/31/2019"))