Formulas have stopped working- asking for your help to figure out why?

[wmichael]

Hello. On this spreadsheet, used to track media clippings about my organization some formulas stopped working at line 355 where I inserted copied cells. On the inserted cells I corrected the date formatting to match my formula. The inserted cells are working with some formulas but not others and I am s and the inserted cells are working with other formulas and I am at a loss to figure out why. Please see this XL2BB clip and let me know if you need more information. Thank you in advance for your help.

2019-22 Media Clips v04.xlsx
	BS	BT	BU	BV	BW	BX	BY	BZ	CA	CB	CC	CD	CE	CF	CG	CH	CI	CJ	CK	CL	CM	CN	CO	CP	CQ	CR	CS
352				0	0			1						1	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	Lake Shelbyville to hold Life Jacket Drive
353				0	0									0	Sea Ray and Freedom Boat Club win National Boating Industry Safety Awards	Brunswick	N/A	N/A	LAKE FOREST	IL	USA	74,354	$6,340	- Web	12-11-2020	12/14/2020	Sea Ray and Freedom Boat Club win National Boating Industry Safety Awards
354			1	8500	404							1		1	National Boating Industry Safety Award Winners Announced by Sea Tow Foundation	Outdoor Wire (The)	N/A	N/A	GLEN ALLEN	VA	USA	1,458	$27	- Web	12-11-2020	12/14/2020	National Boating Industry Safety Award Winners Announced by Sea Tow Foundation | Outdoor Wire
355			1	0	0									1	Youre 25 Times More Likely to Die in the Winter	Bass Angler Magazine	N/A	N/A	SAN RAMON	CA	USA	8,506	$702	- Web	12-12-2020	12/14/2020	http://bassanglermag.com/youre-25-t...ure-25-times-more-likely-to-die-in-the-winter
356			1	0	0									1	Cold Weather Boating Safety Tips	Outdoor Wire (The)	N/A	N/A	GLEN ALLEN	VA	USA	1,458	$21	- Web	12-10-2020	12/14/2020	Cold Weather Boating Safety Tips | Outdoor Wire
357	1	1		0	0									1	Sea Ray and Freedom Boat Club win National Boating Industry Safety Awards	Public	N/A	N/A	NEW YORK	NY	USA	157	$407	- Web	12-11-2020	12/14/2020	Brunswick Corporation (via Public) / Sea Ray and Freedom Boat Club win National Boating Industry Safety Awards
358	1	1		0	0									1	National Boating Industry Safety Award Winners Announced by Sea Tow Foundation	Fishing Wire (The)	N/A	N/A	GLEN ALLEN	VA	USA	3,372	$55	- Web	12-11-2020	12/14/2020	<p>National Boating Industry Safety Award Winners Announced by Sea Tow Foundation</p> | Fishing Wire
359	1	1		0	0									1	1Safety at Sea - Trade Only Today	Soundings: Trade Only	N/A	N/A	ESSEX	CT	USA	3,034	$12	- Web	12-11-2020	12/14/2020	Safety at Sea
360			1	0	0									1	Cold Weather Boating Safety Tips	Fishing Wire (The)	N/A	N/A	GLEN ALLEN	VA	USA	3,372	$43	- Web	12-10-2020	12/14/2020	Cold Weather Boating Safety Tips | Fishing Wire
361	1	1		0	0									1	Sea Tow Foundation announces National Boating Industry Safety Award winners - Boating Industry	Boating Industry Online	N/A	N/A	MAPLE GROVE	MN	USA	5,890	$61	- Web	12-10-2020	12/14/2020	Sea Tow Foundation announces National Boating Industry Safety Award winners | Boating Industry
362				0	0									0	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	http://www.yoursun.com/englewood/co...cle_f9ed91da-9c15-11e9-9291-ebef04e1583c.html
363			1	0	0									1	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	http://swflparentchild.com/parenting/where-to-find-loaner-life-jackets-in-sw-fl/
364			1	0	0
raw

Cell Formulas
Range	Formula
BV352	BV352	=IF(BU352=1,CN352,"0")
BW352	BW352	=IF(BU352=1,CO352,"0")
BV353:BV364	BV353	=IF(BU353=1,CN362,"0")
BW353:BW364	BW353	=IF(BU353=1,CO362,"0")

 

[wmichael]

The formulas on another tab that pulls data from the one above also are not working.

2019-22 Media Clips v04.xlsx
	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V
1	SEA TOW FOUNDATION MONITORING OF PRINT, WEB, AND EVENTS	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
2	SUMMARY
3	190 Headlines
4	Distributed by 177 Outlets
5	Across 141 Cities
6	and 34 States
7	Produced a combined total of 106,413,294 Circulation, Impressions, and Event Attendees
8	With a total of $6,162,074 in Media Value
9	Consisting of 75 Print 287 and Web Headlines, and attendees to 0 Events that have seen our boating safety messages and break down to
10	2,556,797 Print Circulation
11	$140,239 Print Value
12	103,856,497 Web Impressions
13	$6,021,835 Web Value
14	0 Event Attendees
15	DETAILS
16	93 Life Jacket Loaner Program	#VALUE!										#VALUE!	#VALUE!	#VALUE!	#VALUE!	#VALUE!	#VALUE!	#VALUE!
17	26,303,841 Life Jacket Impressions
18	Life Jacket Impressions Valued at $3,942,100
19	1 Life Jacket Loaner Data Base
20	1 Life Jacket Drive
21	2 Hero Award
22	5 Life Jacket Selfie Giveaway Contest
23	2 WCIND Grant
24	114 Sober Skipper Program												#VALUE!
25	55,635,708 Sober Skipper Impressions												#VALUE!
26	Sober Skipper Mentions Impressions Valued at $5,191,784
27	100 National Boating Industry Safety Awards
28	28 Flare Disposal Program
29	25,494,762 Flare Disposal Impressions
30	Flare Disposal Impressions Valued at $295,668
31	4 American Marine Sports/Maritec Industries
32	42,278 Impressions
33	Valued at $631
dashboard

Cell Formulas
Range	Formula
D3	D3	=raw!CG1
D4	D4	=raw!CH1
D5	D5	=raw!CK1
D6	D6	=raw!CL1
D7	D7	=raw!CN1
D8	D8	=raw!CO1
D9	D9	=raw!CP1
D10	D10	=raw!CT1
D11	D11	=raw!CU1
D12	D12	=raw!CV1
D13	D13	=raw!CW1
D14	D14	=raw!CX1
E16	E16	=SUMIFS(raw!BU2:BU556,raw!CR2:CR565,">"&DATEVALUE("7/1/2019"),raw!CR2:CR565,"<"&DATEVALUE("7/31/2019"))
O16	O16	=SUMIFS(raw!BU2:BU556,raw!CR2:CR565,">"&DATEVALUE("5/1/2020"),raw!CR2:CR565,"<"&DATEVALUE("5/31/2020"))
P16	P16	=SUMIFS(raw!BU2:BU556,raw!CR2:CR565,">"&DATEVALUE("6/1/2020"),raw!CR2:CR565,"<"&DATEVALUE("6/30/2020"))
Q16	Q16	=SUMIFS(raw!BU2:BU556,raw!CR2:CR565,">"&DATEVALUE("7/1/2020"),raw!CR2:CR565,"<"&DATEVALUE("7/31/2020"))
R16	R16	=SUMIFS(raw!BU2:BU556,raw!CR2:CR565,">"&DATEVALUE("8/1/2020"),raw!CR2:CR565,"<"&DATEVALUE("8/31/2020"))
S16	S16	=SUMIFS(raw!BU2:BU556,raw!CR2:CR565,">"&DATEVALUE("9/1/2020"),raw!CR2:CR565,"<"&DATEVALUE("9/30/2020"))
T16	T16	=SUMIFS(raw!BU2:BU556,raw!CR2:CR565,">"&DATEVALUE("10/1/2020"),raw!CR2:CR565,"<"&DATEVALUE("10/30/2020"))
U16	U16	=SUMIFS(raw!BU2:BU556,raw!CR2:CR565,">"&DATEVALUE("11/1/2020"),raw!CR2:CR565,"<"&DATEVALUE("11/30/2020"))
P24	P24	=SUMIFS(raw!BP2:BP560,raw!CR2:CR569,">"&DATEVALUE("6/1/2020"),raw!CR2:CR569,"<"&DATEVALUE("6/30/2020"))
P25	P25	=SUMIFS(raw!BQ2:BQ561,raw!CR2:CR570,">"&DATEVALUE("6/1/2020"),raw!CR2:CR570,"<"&DATEVALUE("6/30/2020"))
D16	D16	=raw!BU1
D17	D17	=raw!BV1
D18	D18	=raw!BW1
D19	D19	=raw!BY1
D20	D20	=raw!BZ1
D21	D21	=raw!CA1
D22	D22	=raw!CB1
D23	D23	=raw!CD1
D24	D24	=raw!BP1
D25	D25	=raw!BQ1
D26	D26	=raw!BR1
D27	D27	=raw!BT1
D28	D28	=raw!BM1
D29	D29	=raw!BN1
D30	D30	=raw!BO1
D31	D31	=raw!A1
D32	D32	=raw!B1
D33	D33	=raw!C1

Named Ranges
Name	Refers To	Cells
raw!_FilterDatabase	=raw!$A$1:$CW$1	D31

 

[Fluff]

That's probably for the same reason.
IMO inserting partial rows in a data set is a recipe for disaster & should be avoided.

 

[wmichael]

I solved the matter by retyping the formulas.