Appendix-Thread-Evaluate-Range-(-Codes-for-other-Threads-HTML-Tables-etc-)

[DocAElstein]

In support of answer to this Thread
http://www.excelfox.com/forum/showth...chedule-scores

_____ Workbook: NFL 2019 Schedule.xlsx ( Using Excel 2007 32 bit )

Row\Col	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S
1	Week # 1			09.08.19
2	V Team	GB	LAR	WAS	BUF	ATL	BAL	KC	TEN	IND	CIN	SF	NYG	DET	PIT	HOU	DEN	TOTAL
3	V Score																	0
4	H Score
5	H Team	CHI	CAR	PHI	NYJ	MIN	MIA	JAX	CLE	LAC	SEA	TB	DAL	ARI	NE	NO	OAK
6	BYES
7
8	Week # 2			09.15.19
9	V Team	TB	ARI	DAL	IND	SEA	BUF	SF	LAC	MIN	JAX	NE	KC	NO	CHI	PHI	CLE
10	V Score																	0
11	H Score
12	H Team	CAR	BAL	WAS	TEN	PIT	NYG	CIN	DET	GB	HOU	MIA	OAK	LAR	DEN	ATL	NYJ
13	BYES
14

Worksheet: 2019


_____ Workbook: NFL 2019 Schedule.xlsx ( Using Excel 2007 32 bit )

Row\Col	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S
1	Week # 1			09.08.19
2	V Team	GB	LAR	WAS	BUF	ATL	BAL	KC	TEN	IND	CIN	SF	NYG	DET	PIT	HOU	DEN	TOTAL
3	V Score																	=SUM(B3:Q4)
4	H Score
5	H Team	CHI	CAR	PHI	NYJ	MIN	MIA	JAX	CLE	LAC	SEA	TB	DAL	ARI	NE	NO	OAK
6	BYES
7
8	Week # 2			09.15.19
9	V Team	TB	ARI	DAL	IND	SEA	BUF	SF	LAC	MIN	JAX	NE	KC	NO	CHI	PHI	CLE
10	V Score																	=SUM(B10:Q11)
11	H Score
12	H Team	CAR	BAL	WAS	TEN	PIT	NYG	CIN	DET	GB	HOU	MIA	OAK	LAR	DEN	ATL	NYJ
13	BYES
14

Worksheet: 2019