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

wmichael · Dec 21, 2020

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

NAPLES

FL

USA

69,903

$1,052

- Web

12-02-2019

12/4/2019

20

Downriver communities wrap up year

Voice (The)

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

NEW HAVEN

CT

USA

111,844

$3,581

- Web

01-08-2020

1/9/2020

22

With Flying Colors - Soundings Online

Soundings

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

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

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

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

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:")

wmichael · Dec 29, 2020

Hello. I am asking for your help with a discrepancy that has appeared in the solution identified for this post and asking for your help to identify and fix it- please see X3, X5-7 in this example. The answer should be zero and not 1 because the date column the formula is pulling from does not contain 2021 dates. Thank you in advance for your help with this.

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

V

W

X

1

SEA TOW FOUNDATION PRINT AND WEB ARTICLES; AND EVENTS

Grand Totals

2019 (Jul-Dec)

2020

2021

Jul-19

Aug-19

Sep-19

Oct-19

Nov-19

Dec-19

Jan-20

Feb-20

Mar-20

Apr-20

May-20

Jun-20

Jul-20

Aug-20

Sep-20

Oct-20

Nov-20

Dec-20

Jan-21

2

SUMMARY

3

Unique Headlines about Sea Tow Foundation efforts

4

Quantity of articles generated by headlines

5

Unique outlets that distributed media

6

Unique Cities where media was distributed

7

Unique States where media was distributed

8

Total of Print Circulation, Web Impressions, and Event Attendance

9

Total Media Value

dashboard

Cell Formulas
Range	Formula
B3	B3	=COUNTA(UNIQUE(FILTER(raw!$DC$2:$DC$1000,(raw!$DN$2:$DN$1000>=DATE(2019,1,1))*(raw!$DN$2:$DN$1000<=DATE(2020,12,31)),"")))
C3	C3	=COUNTA(UNIQUE(FILTER(raw!$DC$2:$DC$1000,(raw!$DN$2:$DN$1000>=DATE(2019,1,1))*(raw!$DN$2:$DN$1000<=DATE(2019,12,31)),"")))
D3	D3	=COUNTA(UNIQUE(FILTER(raw!$DC$2:$DC$1000,(raw!$DN$2:$DN$1000>=DATE(2020,1,1))*(raw!$DN$2:$DN$1000<=DATE(2020,12,31)),"")))
B4,B8:B9	B4	=SUM(C4:E4)
C4,C8:C9	C4	=SUM(F4:K4)
D4,D8:D9	D4	=SUM(L4:W4)
B5	B5	=COUNTA(UNIQUE(FILTER(raw!$DD$2:$DD$1001,(raw!$DN$2:$DN$1001>=DATE(2019,1,1))*(raw!$DN$2:$DN$1001<=DATE(2020,12,31)),"")))
C5	C5	=COUNTA(UNIQUE(FILTER(raw!$DD$2:$DD$1001,(raw!$DN$2:$DN$1001>=DATE(2019,1,1))*(raw!$DN$2:$DN$1001<=DATE(2019,12,31)),"")))
D5	D5	=COUNTA(UNIQUE(FILTER(raw!$DD$2:$DD$1001,(raw!$DN$2:$DN$1001>=DATE(2020,1,1))*(raw!$DN$2:$DN$1001<=DATE(2020,12,31)),"")))
B6	B6	=COUNTA(UNIQUE(FILTER(raw!$DG$2:$DG$1001,(raw!$DN$2:$DN$1001>=DATE(2019,1,1))*(raw!$DN$2:$DN$1001<=DATE(2020,12,31)),"")))
C6	C6	=COUNTA(UNIQUE(FILTER(raw!$DG$2:$DG$1001,(raw!$DN$2:$DN$1001>=DATE(2019,1,1))*(raw!$DN$2:$DN$1001<=DATE(2019,12,31)),"")))
D6	D6	=COUNTA(UNIQUE(FILTER(raw!$DG$2:$DG$1001,(raw!$DN$2:$DN$1001>=DATE(2020,1,1))*(raw!$DN$2:$DN$1001<=DATE(2020,12,31)),"")))
B7	B7	=COUNTA(UNIQUE(FILTER(raw!$DH$2:$DH$1001,(raw!$DN$2:$DN$1001>=DATE(2019,1,1))*(raw!$DN$2:$DN$1001<=DATE(2020,12,31)),"")))
C7	C7	=COUNTA(UNIQUE(FILTER(raw!$DH$2:$DH$1001,(raw!$DN$2:$DN$1001>=DATE(2019,1,1))*(raw!$DN$2:$DN$1001<=DATE(2019,12,31)),"")))
D7	D7	=COUNTA(UNIQUE(FILTER(raw!$DH$2:$DH$1001,(raw!$DN$2:$DN$1001>=DATE(2020,1,1))*(raw!$DN$2:$DN$1001<=DATE(2020,12,31)),"")))
F3	F3	=COUNTA(UNIQUE(FILTER(raw!$DC$2:$DC$1000,(raw!$DN$2:$DN$1000>=DATE(2019,7,1))*(raw!$DN$2:$DN$1000<=DATE(2019,7,31)),"")))
G3	G3	=COUNTA(UNIQUE(FILTER(raw!$DC$2:$DC$1000,(raw!$DN$2:$DN$1000>=DATE(2019,8,1))*(raw!$DN$2:$DN$1000<=DATE(2019,8,31)),"")))
H3	H3	=COUNTA(UNIQUE(FILTER(raw!$DC$2:$DC$1000,(raw!$DN$2:$DN$1000>=DATE(2019,9,1))*(raw!$DN$2:$DN$1000<=DATE(2019,9,30)),"")))
I3	I3	=COUNTA(UNIQUE(FILTER(raw!$DC$2:$DC$1000,(raw!$DN$2:$DN$1000>=DATE(2019,10,1))*(raw!$DN$2:$DN$1000<=DATE(2019,10,31)),"")))
J3	J3	=COUNTA(UNIQUE(FILTER(raw!$DC$2:$DC$1000,(raw!$DN$2:$DN$1000>=DATE(2019,11,1))*(raw!$DN$2:$DN$1000<=DATE(2019,11,30)),"")))
K3	K3	=COUNTA(UNIQUE(FILTER(raw!$DC$2:$DC$1000,(raw!$DN$2:$DN$1000>=DATE(2019,12,1))*(raw!$DN$2:$DN$1000<=DATE(2019,12,31)),"")))
L3	L3	=COUNTA(UNIQUE(FILTER(raw!$DC$2:$DC$1000,(raw!$DN$2:$DN$1000>=DATE(2020,1,1))*(raw!$DN$2:$DN$1000<=DATE(2020,1,31)),"")))
M3	M3	=COUNTA(UNIQUE(FILTER(raw!$DC$2:$DC$1000,(raw!$DN$2:$DN$1000>=DATE(2020,2,1))*(raw!$DN$2:$DN$1000<=DATE(2020,2,29)),"")))
N3	N3	=COUNTA(UNIQUE(FILTER(raw!$DC$2:$DC$1000,(raw!$DN$2:$DN$1000>=DATE(2020,3,1))*(raw!$DN$2:$DN$1000<=DATE(2020,3,31)),"")))
O3	O3	=COUNTA(UNIQUE(FILTER(raw!$DC$2:$DC$1000,(raw!$DN$2:$DN$1000>=DATE(2020,4,1))*(raw!$DN$2:$DN$1000<=DATE(2020,4,30)),"")))
P3	P3	=COUNTA(UNIQUE(FILTER(raw!$DC$2:$DC$1000,(raw!$DN$2:$DN$1000>=DATE(2020,5,1))*(raw!$DN$2:$DN$1000<=DATE(2020,5,31)),"")))
Q3	Q3	=COUNTA(UNIQUE(FILTER(raw!$DC$2:$DC$1000,(raw!$DN$2:$DN$1000>=DATE(2020,6,1))*(raw!$DN$2:$DN$1000<=DATE(2020,6,30)),"")))
R3	R3	=COUNTA(UNIQUE(FILTER(raw!$DC$2:$DC$1000,(raw!$DN$2:$DN$1000>=DATE(2020,7,1))*(raw!$DN$2:$DN$1000<=DATE(2020,7,31)),"")))
S3	S3	=COUNTA(UNIQUE(FILTER(raw!$DC$2:$DC$1000,(raw!$DN$2:$DN$1000>=DATE(2020,8,1))*(raw!$DN$2:$DN$1000<=DATE(2020,8,31)),"")))
T3	T3	=COUNTA(UNIQUE(FILTER(raw!$DC$2:$DC$1000,(raw!$DN$2:$DN$1000>=DATE(2020,9,1))*(raw!$DN$2:$DN$1000<=DATE(2020,9,30)),"")))
U3	U3	=COUNTA(UNIQUE(FILTER(raw!$DC$2:$DC$1000,(raw!$DN$2:$DN$1000>=DATE(2020,10,1))*(raw!$DN$2:$DN$1000<=DATE(2020,10,31)),"")))
V3	V3	=COUNTA(UNIQUE(FILTER(raw!$DC$2:$DC$1000,(raw!$DN$2:$DN$1000>=DATE(2020,11,1))*(raw!$DN$2:$DN$1000<=DATE(2020,11,30)),"")))
W3	W3	=COUNTA(UNIQUE(FILTER(raw!$DC$2:$DC$1000,(raw!$DN$2:$DN$1000>=DATE(2020,12,1))*(raw!$DN$2:$DN$1000<=DATE(2020,12,31)),"")))
X3	X3	=COUNTA(UNIQUE(FILTER(raw!$DC$2:$DC$1000,(raw!$DN$2:$DN$1000>=DATE(2021,1,1))*(raw!$DN$2:$DN$1000<=DATE(2021,1,31)),"")))
F4	F4	=COUNTIFS(raw!$DN2:$DN1000,">=7/1/2019",raw!$DN2:$DN$1000,"<=7/31/2019")
G4	G4	=COUNTIFS(raw!$DN2:$DN1000,">=8/1/2019",raw!$DN2:$DN$1000,"<=8/31/2019")
H4	H4	=COUNTIFS(raw!$DN2:$DN1000,">=9/1/2019",raw!$DN2:$DN$1000,"<=9/30/2019")
I4	I4	=COUNTIFS(raw!$DN2:$DN1000,">=10/1/2019",raw!$DN2:$DN$1000,"<=10/31/2019")
J4	J4	=COUNTIFS(raw!$DN2:$DN1000,">=11/1/2019",raw!$DN2:$DN$1000,"<=11/30/2019")
K4	K4	=COUNTIFS(raw!$DN2:$DN1000,">=12/1/2019",raw!$DN2:$DN$1000,"<=12/31/2019")
L4	L4	=COUNTIFS(raw!$DN2:$DN1000,">=1/1/2020",raw!$DN2:$DN$1000,"<=1/31/2020")
M4	M4	=COUNTIFS(raw!$DN2:$DN1000,">=2/1/2020",raw!$DN2:$DN$1000,"<=2/29/2020")
N4	N4	=COUNTIFS(raw!$DN2:$DN1000,">=3/1/2020",raw!$DN2:$DN$1000,"<=3/31/2020")
O4	O4	=COUNTIFS(raw!$DN2:$DN1000,">=4/1/2020",raw!$DN2:$DN$1000,"<=4/30/2020")
P4	P4	=COUNTIFS(raw!$DN2:$DN1000,">=5/1/2020",raw!$DN2:$DN$1000,"<=5/31/2020")
Q4	Q4	=COUNTIFS(raw!$DN2:$DN1000,">=6/1/2020",raw!$DN2:$DN$1000,"<=6/30/2020")
R4	R4	=COUNTIFS(raw!$DN2:$DN1000,">=7/1/2020",raw!$DN2:$DN$1000,"<=7/31/2020")
S4	S4	=COUNTIFS(raw!$DN2:$DN1000,">=8/1/2020",raw!$DN2:$DN$1000,"<=8/31/2020")
T4	T4	=COUNTIFS(raw!$DN2:$DN1000,">=9/1/2020",raw!$DN2:$DN$1000,"<=9/30/2020")
U4	U4	=COUNTIFS(raw!$DN2:$DN1000,">=10/1/2020",raw!$DN2:$DN$1000,"<=10/31/2020")
V4	V4	=COUNTIFS(raw!$DN2:$DN1000,">=11/1/2020",raw!$DN2:$DN$1000,"<=11/30/2020")
W4	W4	=COUNTIFS(raw!$DN2:$DN1000,">=12/1/2020",raw!$DN2:$DN$1000,"<=12/31/2020")
X4	X4	=COUNTIFS(raw!$DN2:$DN1000,">=1/1/2021",raw!$DN2:$DN$1000,"<=1/31/2021")
F5	F5	=COUNTA(UNIQUE(FILTER(raw!$DD$2:$DD$1001,(raw!$DN$2:$DN$1001>=DATE(2019,7,1))*(raw!$DN$2:$DN$1001<=DATE(2019,7,31)),"")))
G5	G5	=COUNTA(UNIQUE(FILTER(raw!$DD$2:$DD$1001,(raw!$DN$2:$DN$1001>=DATE(2019,8,1))*(raw!$DN$2:$DN$1001<=DATE(2019,8,31)),"")))
H5	H5	=COUNTA(UNIQUE(FILTER(raw!$DD$2:$DD$1001,(raw!$DN$2:$DN$1001>=DATE(2019,9,1))*(raw!$DN$2:$DN$1001<=DATE(2019,9,30)),"")))
I5	I5	=COUNTA(UNIQUE(FILTER(raw!$DD$2:$DD$1001,(raw!$DN$2:$DN$1001>=DATE(2019,10,1))*(raw!$DN$2:$DN$1001<=DATE(2019,10,31)),"")))
J5	J5	=COUNTA(UNIQUE(FILTER(raw!$DD$2:$DD$1001,(raw!$DN$2:$DN$1001>=DATE(2019,11,1))*(raw!$DN$2:$DN$1001<=DATE(2019,11,3)),"")))
K5	K5	=COUNTA(UNIQUE(FILTER(raw!$DD$2:$DD$1001,(raw!$DN$2:$DN$1001>=DATE(2019,12,1))*(raw!$DN$2:$DN$1001<=DATE(2019,12,31)),"")))
L5	L5	=COUNTA(UNIQUE(FILTER(raw!$DD$2:$DD$1001,(raw!$DN$2:$DN$1001>=DATE(2020,1,1))*(raw!$DN$2:$DN$1001<=DATE(2020,1,31)),"")))
M5	M5	=COUNTA(UNIQUE(FILTER(raw!$DD$2:$DD$1001,(raw!$DN$2:$DN$1001>=DATE(2020,2,1))*(raw!$DN$2:$DN$1001<=DATE(2020,2,29)),"")))
N5	N5	=COUNTA(UNIQUE(FILTER(raw!$DD$2:$DD$1001,(raw!$DN$2:$DN$1001>=DATE(2020,3,1))*(raw!$DN$2:$DN$1001<=DATE(2020,3,31)),"")))
O5	O5	=COUNTA(UNIQUE(FILTER(raw!$DD$2:$DD$1001,(raw!$DN$2:$DN$1001>=DATE(2020,4,1))*(raw!$DN$2:$DN$1001<=DATE(2020,4,30)),"")))
P5	P5	=COUNTA(UNIQUE(FILTER(raw!$DD$2:$DD$1001,(raw!$DN$2:$DN$1001>=DATE(2020,5,1))*(raw!$DN$2:$DN$1001<=DATE(2020,5,31)),"")))
Q5	Q5	=COUNTA(UNIQUE(FILTER(raw!$DD$2:$DD$1001,(raw!$DN$2:$DN$1001>=DATE(2020,6,1))*(raw!$DN$2:$DN$1001<=DATE(2020,6,30)),"")))
R5	R5	=COUNTA(UNIQUE(FILTER(raw!$DD$2:$DD$1001,(raw!$DN$2:$DN$1001>=DATE(2020,7,1))*(raw!$DN$2:$DN$1001<=DATE(2020,7,31)),"")))
S5	S5	=COUNTA(UNIQUE(FILTER(raw!$DD$2:$DD$1001,(raw!$DN$2:$DN$1001>=DATE(2020,8,1))*(raw!$DN$2:$DN$1001<=DATE(2020,8,31)),"")))
T5	T5	=COUNTA(UNIQUE(FILTER(raw!$DD$2:$DD$1001,(raw!$DN$2:$DN$1001>=DATE(2020,9,1))*(raw!$DN$2:$DN$1001<=DATE(2020,9,30)),"")))
U5	U5	=COUNTA(UNIQUE(FILTER(raw!$DD$2:$DD$1001,(raw!$DN$2:$DN$1001>=DATE(2020,10,1))*(raw!$DN$2:$DN$1001<=DATE(2020,10,31)),"")))
V5	V5	=COUNTA(UNIQUE(FILTER(raw!$DD$2:$DD$1001,(raw!$DN$2:$DN$1001>=DATE(2020,11,1))*(raw!$DN$2:$DN$1001<=DATE(2020,11,30)),"")))
W5	W5	=COUNTA(UNIQUE(FILTER(raw!$DD$2:$DD$1001,(raw!$DN$2:$DN$1001>=DATE(2020,12,1))*(raw!$DN$2:$DN$1001<=DATE(2020,12,31)),"")))
X5	X5	=COUNTA(UNIQUE(FILTER(raw!$DD$2:$DD$1001,(raw!$DN$2:$DN$1001>=DATE(2021,1,1))*(raw!$DN$2:$DN$1000<=DATE(2021,1,31)),"")))
F6	F6	=COUNTA(UNIQUE(FILTER(raw!$DG$2:$DG$1001,(raw!$DN$2:$DN$1001>=DATE(2019,7,1))*(raw!$DN$2:$DN$1001<=DATE(2019,7,31)),"")))
G6	G6	=COUNTA(UNIQUE(FILTER(raw!$DG$2:$DG$1001,(raw!$DN$2:$DN$1001>=DATE(2019,8,1))*(raw!$DN$2:$DN$1001<=DATE(2019,8,31)),"")))
H6	H6	=COUNTA(UNIQUE(FILTER(raw!$DG$2:$DG$1001,(raw!$DN$2:$DN$1001>=DATE(2019,9,1))*(raw!$DN$2:$DN$1001<=DATE(2019,9,30)),"")))
I6	I6	=COUNTA(UNIQUE(FILTER(raw!$DG$2:$DG$1001,(raw!$DN$2:$DN$1001>=DATE(2019,10,1))*(raw!$DN$2:$DN$1001<=DATE(2019,10,31)),"")))
J6	J6	=COUNTA(UNIQUE(FILTER(raw!$DG$2:$DG$1001,(raw!$DN$2:$DN$1001>=DATE(2019,11,1))*(raw!$DN$2:$DN$1001<=DATE(2019,11,30)),"")))
K6	K6	=COUNTA(UNIQUE(FILTER(raw!$DG$2:$DG$1001,(raw!$DN$2:$DN$1001>=DATE(2019,12,1))*(raw!$DN$2:$DN$1001<=DATE(2019,12,31)),"")))
L6	L6	=COUNTA(UNIQUE(FILTER(raw!$DG$2:$DG$1001,(raw!$DN$2:$DN$1001>=DATE(2020,1,1))*(raw!$DN$2:$DN$1001<=DATE(2020,1,31)),"")))
M6	M6	=COUNTA(UNIQUE(FILTER(raw!$DG$2:$DG$1001,(raw!$DN$2:$DN$1001>=DATE(2020,2,1))*(raw!$DN$2:$DN$1001<=DATE(2020,2,29)),"")))
N6	N6	=COUNTA(UNIQUE(FILTER(raw!$DG$2:$DG$1001,(raw!$DN$2:$DN$1001>=DATE(2020,3,1))*(raw!$DN$2:$DN$1001<=DATE(2020,3,31)),"")))
O6	O6	=COUNTA(UNIQUE(FILTER(raw!$DG$2:$DG$1001,(raw!$DN$2:$DN$1001>=DATE(2020,4,1))*(raw!$DN$2:$DN$1001<=DATE(2020,4,30)),"")))
P6	P6	=COUNTA(UNIQUE(FILTER(raw!$DG$2:$DG$1001,(raw!$DN$2:$DN$1001>=DATE(2020,5,1))*(raw!$DN$2:$DN$1001<=DATE(2020,5,31)),"")))
Q6	Q6	=COUNTA(UNIQUE(FILTER(raw!$DG$2:$DG$1001,(raw!$DN$2:$DN$1001>=DATE(2020,6,1))*(raw!$DN$2:$DN$1001<=DATE(2020,6,30)),"")))
R6	R6	=COUNTA(UNIQUE(FILTER(raw!$DG$2:$DG$1001,(raw!$DN$2:$DN$1001>=DATE(2020,7,1))*(raw!$DN$2:$DN$1001<=DATE(2020,7,31)),"")))
S6	S6	=COUNTA(UNIQUE(FILTER(raw!$DG$2:$DG$1001,(raw!$DN$2:$DN$1001>=DATE(2020,8,1))*(raw!$DN$2:$DN$1001<=DATE(2020,8,31)),"")))
T6	T6	=COUNTA(UNIQUE(FILTER(raw!$DG$2:$DG$1001,(raw!$DN$2:$DN$1001>=DATE(2020,9,1))*(raw!$DN$2:$DN$1001<=DATE(2020,9,3)),"")))
U6	U6	=COUNTA(UNIQUE(FILTER(raw!$DG$2:$DG$1001,(raw!$DN$2:$DN$1001>=DATE(2020,10,1))*(raw!$DN$2:$DN$1001<=DATE(2020,10,31)),"")))
V6	V6	=COUNTA(UNIQUE(FILTER(raw!$DG$2:$DG$1001,(raw!$DN$2:$DN$1001>=DATE(2020,11,1))*(raw!$DN$2:$DN$1001<=DATE(2020,11,30)),"")))
W6	W6	=COUNTA(UNIQUE(FILTER(raw!$DG$2:$DG$1001,(raw!$DN$2:$DN$1001>=DATE(2020,12,1))*(raw!$DN$2:$DN$1001<=DATE(2020,12,31)),"")))
X6	X6	=COUNTA(UNIQUE(FILTER(raw!$DG$2:$DG$1001,(raw!$DN$2:$DN$1001>=DATE(2021,1,1))*(raw!$DN$2:$DN$1001<=DATE(2021,1,31)),"")))
F7	F7	=COUNTA(UNIQUE(FILTER(raw!$DH$2:$DH$1001,(raw!$DN$2:$DN$1001>=DATE(2019,7,1))*(raw!$DN$2:$DN$1001<=DATE(2019,7,31)),"")))
G7	G7	=COUNTA(UNIQUE(FILTER(raw!$DH$2:$DH$1001,(raw!$DN$2:$DN$1001>=DATE(2019,8,1))*(raw!$DN$2:$DN$1001<=DATE(2019,8,31)),"")))
H7	H7	=COUNTA(UNIQUE(FILTER(raw!$DH$2:$DH$1001,(raw!$DN$2:$DN$1001>=DATE(2019,9,1))*(raw!$DN$2:$DN$1001<=DATE(2019,9,30)),"")))
I7	I7	=COUNTA(UNIQUE(FILTER(raw!$DH$2:$DH$1001,(raw!$DN$2:$DN$1001>=DATE(2019,10,1))*(raw!$DN$2:$DN$1001<=DATE(2019,10,31)),"")))
J7	J7	=COUNTA(UNIQUE(FILTER(raw!$DH$2:$DH$1001,(raw!$DN$2:$DN$1001>=DATE(2019,11,1))*(raw!$DN$2:$DN$1001<=DATE(2019,11,30)),"")))
K7	K7	=COUNTA(UNIQUE(FILTER(raw!$DH$2:$DH$1001,(raw!$DN$2:$DN$1001>=DATE(2019,12,1))*(raw!$DN$2:$DN$1001<=DATE(2019,12,31)),"")))
L7	L7	=COUNTA(UNIQUE(FILTER(raw!$DH$2:$DH$1001,(raw!$DN$2:$DN$1001>=DATE(2020,1,1))*(raw!$DN$2:$DN$1001<=DATE(2020,1,31)),"")))
M7	M7	=COUNTA(UNIQUE(FILTER(raw!$DH$2:$DH$1001,(raw!$DN$2:$DN$1001>=DATE(2020,2,1))*(raw!$DN$2:$DN$1001<=DATE(2020,2,29)),"")))
N7	N7	=COUNTA(UNIQUE(FILTER(raw!$DH$2:$DH$1001,(raw!$DN$2:$DN$1001>=DATE(2020,3,1))*(raw!$DN$2:$DN$1001<=DATE(2020,3,31)),"")))
O7	O7	=COUNTA(UNIQUE(FILTER(raw!$DH$2:$DH$1001,(raw!$DN$2:$DN$1001>=DATE(2020,4,1))*(raw!$DN$2:$DN$1001<=DATE(2020,4,30)),"")))
P7	P7	=COUNTA(UNIQUE(FILTER(raw!$DH$2:$DH$1001,(raw!$DN$2:$DN$1001>=DATE(2020,5,1))*(raw!$DN$2:$DN$1001<=DATE(2020,5,31)),"")))
Q7	Q7	=COUNTA(UNIQUE(FILTER(raw!$DH$2:$DH$1001,(raw!$DN$2:$DN$1001>=DATE(2020,6,1))*(raw!$DN$2:$DN$1001<=DATE(2020,6,30)),"")))
R7	R7	=COUNTA(UNIQUE(FILTER(raw!$DH$2:$DH$1001,(raw!$DN$2:$DN$1001>=DATE(2020,7,1))*(raw!$DN$2:$DN$1001<=DATE(2020,7,31)),"")))
S7	S7	=COUNTA(UNIQUE(FILTER(raw!$DH$2:$DH$1001,(raw!$DN$2:$DN$1001>=DATE(2020,8,1))*(raw!$DN$2:$DN$1001<=DATE(2020,8,31)),"")))
T7	T7	=COUNTA(UNIQUE(FILTER(raw!$DH$2:$DH$1001,(raw!$DN$2:$DN$1001>=DATE(2020,9,1))*(raw!$DN$2:$DN$1001<=DATE(2020,9,30)),"")))
U7	U7	=COUNTA(UNIQUE(FILTER(raw!$DH$2:$DH$1001,(raw!$DN$2:$DN$1001>=DATE(2020,10,1))*(raw!$DN$2:$DN$1001<=DATE(2020,10,31)),"")))
V7	V7	=COUNTA(UNIQUE(FILTER(raw!$DH$2:$DH$1001,(raw!$DN$2:$DN$1001>=DATE(2020,11,1))*(raw!$DN$2:$DN$1001<=DATE(2020,11,30)),"")))
W7	W7	=COUNTA(UNIQUE(FILTER(raw!$DH$2:$DH$1001,(raw!$DN$2:$DN$1001>=DATE(2020,12,1))*(raw!$DN$2:$DN$1001<=DATE(2020,12,31)),"")))
X7	X7	=COUNTA(UNIQUE(FILTER(raw!$DH$2:$DH$1001,(raw!$DN$2:$DN$1001>=DATE(2021,1,1))*(raw!$DN$2:$DN$1001<=DATE(2021,1,31)),"")))
F8	F8	=SUMIFS(raw!$DJ$2:$DJ$980,raw!$DN$2:$DN$980,">"&DATEVALUE("7/1/2019"),raw!$DN$2:$DN$980,"<"&DATEVALUE("7/31/2019"))
G8	G8	=SUMIFS(raw!$DJ$2:$DJ$980,raw!$DN$2:$DN$980,">"&DATEVALUE("8/1/2019"),raw!$DN$2:$DN$980,"<"&DATEVALUE("8/31/2019"))
H8	H8	=SUMIFS(raw!$DJ$2:$DJ$980,raw!$DN$2:$DN$980,">"&DATEVALUE("9/1/2019"),raw!$DN$2:$DN$980,"<"&DATEVALUE("9/30/2019"))
I8	I8	=SUMIFS(raw!$DJ$2:$DJ$980,raw!$DN$2:$DN$980,">"&DATEVALUE("10/1/2019"),raw!$DN$2:$DN$980,"<"&DATEVALUE("10/31/2019"))
J8	J8	=SUMIFS(raw!$DJ$2:$DJ$980,raw!$DN$2:$DN$980,">"&DATEVALUE("11/1/2019"),raw!$DN$2:$DN$980,"<"&DATEVALUE("11/30/2019"))
K8	K8	=SUMIFS(raw!$DJ$2:$DJ$980,raw!$DN$2:$DN$980,">"&DATEVALUE("12/1/2019"),raw!$DN$2:$DN$980,"<"&DATEVALUE("12/31/2019"))
L8	L8	=SUMIFS(raw!$DJ$2:$DJ$980,raw!$DN$2:$DN$980,">"&DATEVALUE("1/1/2020"),raw!$DN$2:$DN$980,"<"&DATEVALUE("1/31/2020"))
M8	M8	=SUMIFS(raw!$DJ$2:$DJ$980,raw!$DN$2:$DN$980,">"&DATEVALUE("2/1/2020"),raw!$DN$2:$DN$980,"<"&DATEVALUE("2/29/2020"))
N8	N8	=SUMIFS(raw!$DJ$2:$DJ$980,raw!$DN$2:$DN$980,">"&DATEVALUE("3/1/2020"),raw!$DN$2:$DN$980,"<"&DATEVALUE("3/31/2020"))
O8	O8	=SUMIFS(raw!$DJ$2:$DJ$980,raw!$DN$2:$DN$980,">"&DATEVALUE("4/1/2020"),raw!$DN$2:$DN$980,"<"&DATEVALUE("4/30/2020"))
P8	P8	=SUMIFS(raw!$DJ$2:$DJ$980,raw!$DN$2:$DN$980,">"&DATEVALUE("5/1/2020"),raw!$DN$2:$DN$980,"<"&DATEVALUE("5/31/2020"))
Q8	Q8	=SUMIFS(raw!$DJ$2:$DJ$980,raw!$DN$2:$DN$980,">"&DATEVALUE("6/1/2020"),raw!$DN$2:$DN$980,"<"&DATEVALUE("6/30/2020"))
R8	R8	=SUMIFS(raw!$DJ$2:$DJ$980,raw!$DN$2:$DN$980,">"&DATEVALUE("7/1/2020"),raw!$DN$2:$DN$980,"<"&DATEVALUE("7/31/2020"))
S8	S8	=SUMIFS(raw!$DJ$2:$DJ$980,raw!$DN$2:$DN$980,">"&DATEVALUE("8/1/2020"),raw!$DN$2:$DN$980,"<"&DATEVALUE("8/31/2020"))
T8	T8	=SUMIFS(raw!$DJ$2:$DJ$980,raw!$DN$2:$DN$980,">"&DATEVALUE("9/1/2020"),raw!$DN$2:$DN$980,"<"&DATEVALUE("9/30/2020"))
U8	U8	=SUMIFS(raw!$DJ$2:$DJ$980,raw!$DN$2:$DN$980,">"&DATEVALUE("10/1/2020"),raw!$DN$2:$DN$980,"<"&DATEVALUE("10/31/2020"))
V8	V8	=SUMIFS(raw!$DJ$2:$DJ$980,raw!$DN$2:$DN$980,">"&DATEVALUE("11/1/2020"),raw!$DN$2:$DN$980,"<"&DATEVALUE("11/30/2020"))
W8	W8	=SUMIFS(raw!$DJ$2:$DJ$980,raw!$DN$2:$DN$980,">"&DATEVALUE("12/1/2020"),raw!$DN$2:$DN$980,"<"&DATEVALUE("12/31/2020"))
X8	X8	=SUMIFS(raw!$DJ$2:$DJ$980,raw!$DN$2:$DN$980,">"&DATEVALUE("1/1/2021"),raw!$DN$2:$DN$980,"<"&DATEVALUE("1/31/2021"))
F9	F9	=SUMIFS(raw!$DK$2:$DK$980,raw!$DN$2:$DN$980,">"&DATEVALUE("7/1/2019"),raw!$DN$2:$DN$980,"<"&DATEVALUE("7/31/2019"))
G9	G9	=SUMIFS(raw!$DK$2:$DK$980,raw!$DN$2:$DN$980,">"&DATEVALUE("8/1/2019"),raw!$DN$2:$DN$980,"<"&DATEVALUE("8/31/2019"))
H9	H9	=SUMIFS(raw!$DK$2:$DK$980,raw!$DN$2:$DN$980,">"&DATEVALUE("9/1/2019"),raw!$DN$2:$DN$980,"<"&DATEVALUE("9/30/2019"))
I9	I9	=SUMIFS(raw!$DK$2:$DK$980,raw!$DN$2:$DN$980,">"&DATEVALUE("10/1/2019"),raw!$DN$2:$DN$980,"<"&DATEVALUE("10/31/2019"))
J9	J9	=SUMIFS(raw!$DK$2:$DK$980,raw!$DN$2:$DN$980,">"&DATEVALUE("11/1/2019"),raw!$DN$2:$DN$980,"<"&DATEVALUE("11/30/2019"))
K9	K9	=SUMIFS(raw!$DK$2:$DK$980,raw!$DN$2:$DN$980,">"&DATEVALUE("12/1/2019"),raw!$DN$2:$DN$980,"<"&DATEVALUE("12/31/2019"))
L9	L9	=SUMIFS(raw!$DK$2:$DK$980,raw!$DN$2:$DN$980,">"&DATEVALUE("1/1/2020"),raw!$DN$2:$DN$980,"<"&DATEVALUE("1/31/2020"))
M9	M9	=SUMIFS(raw!$DK$2:$DK$980,raw!$DN$2:$DN$980,">"&DATEVALUE("2/1/2020"),raw!$DN$2:$DN$980,"<"&DATEVALUE("2/29/2020"))
N9	N9	=SUMIFS(raw!$DK$2:$DK$980,raw!$DN$2:$DN$980,">"&DATEVALUE("3/1/2020"),raw!$DN$2:$DN$980,"<"&DATEVALUE("3/31/2020"))
O9	O9	=SUMIFS(raw!$DK$2:$DK$980,raw!$DN$2:$DN$980,">"&DATEVALUE("4/1/2020"),raw!$DN$2:$DN$980,"<"&DATEVALUE("4/30/2020"))
P9	P9	=SUMIFS(raw!$DK$2:$DK$980,raw!$DN$2:$DN$980,">"&DATEVALUE("5/1/2020"),raw!$DN$2:$DN$980,"<"&DATEVALUE("5/31/2020"))
Q9	Q9	=SUMIFS(raw!$DK$2:$DK$980,raw!$DN$2:$DN$980,">"&DATEVALUE("6/1/2020"),raw!$DN$2:$DN$980,"<"&DATEVALUE("6/30/2020"))
R9	R9	=SUMIFS(raw!$DK$2:$DK$980,raw!$DN$2:$DN$980,">"&DATEVALUE("7/1/2020"),raw!$DN$2:$DN$980,"<"&DATEVALUE("7/31/2020"))
S9	S9	=SUMIFS(raw!$DK$2:$DK$980,raw!$DN$2:$DN$980,">"&DATEVALUE("8/1/2020"),raw!$DN$2:$DN$980,"<"&DATEVALUE("8/31/2020"))
T9	T9	=SUMIFS(raw!$DK$2:$DK$980,raw!$DN$2:$DN$980,">"&DATEVALUE("9/1/2020"),raw!$DN$2:$DN$980,"<"&DATEVALUE("9/30/2020"))
U9	U9	=SUMIFS(raw!$DK$2:$DK$980,raw!$DN$2:$DN$980,">"&DATEVALUE("10/1/2020"),raw!$DN$2:$DN$980,"<"&DATEVALUE("10/31/2020"))
V9	V9	=SUMIFS(raw!$DK$2:$DK$980,raw!$DN$2:$DN$980,">"&DATEVALUE("11/1/2020"),raw!$DN$2:$DN$980,"<"&DATEVALUE("11/30/2020"))
W9	W9	=SUMIFS(raw!$DK$2:$DK$980,raw!$DN$2:$DN$980,">"&DATEVALUE("12/1/2020"),raw!$DN$2:$DN$980,"<"&DATEVALUE("12/31/2020"))
X9	X9	=SUMIFS(raw!$DK$2:$DK$980,raw!$DN$2:$DN$980,">"&DATEVALUE("1/1/2021"),raw!$DN$2:$DN$980,"<"&DATEVALUE("1/31/2021"))

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
X3:X19	Expression	=MOD(ROW(),2)=0	text	NO
A38:W52,A54:W120,Y54:AS120,Y38:AS52,Y3:AS19,A3:W19	Expression	=MOD(ROW(),2)=0	text	NO

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

wmichael

Board Regular

wmichael

Board Regular

Excel Facts

Similar threads

Forum statistics

Share this page

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

wmichael

Board Regular

wmichael

Board Regular

Excel Facts

Similar threads

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock