IF() formula that checks if member data meets filtering criteria

[k3yn0t3]

Hey gang, Can anyone help me with the final formula in my workbook? I need a formula to populate the yellow cells in row 71.

The goal of the formula in row 71 is: If the Member's cell in row 71 has a "1", that member's data is pulled into a master summary tab showing national total of all the member organizations. If the cell in row 71 for a given Member ID is "0" (indicating they don't match the parameters input in B7:B68), its data is multiplied by 0 and thus excluded from the master summary tab's total.

In B7:B68, I have filters where the user can determine the parameters for the data they want shown on a master summary sheet. Some are dates, others are #s, and some use 1s and 0s to indicate "include" or "exclude", respectively.

For context, there is a full excel sheet for each Member ID in my workbook. I'm excluding those here as there are 100s. These sheets have fundraising and payroll information.

I'd welcome your suggestions, and I'm open to a different layout if anyone has a better idea! I just need the formula to yield a 1/0 so that it works with the rest of my workbook's formulas.
...anything that will effectively check each Member's info to determine if it should be included or excluded from summary tab is great.

Thank you in advance. I submitted a version at work yesterday morning and my boss complained the filter isn't working...would massively appreciate any thoughts on this finnicky formula.

Best,
Sam

Teamsters_v38.xlsm
	A	B	C	D	E	F	G
6	Filtering
7	Status
8	Open	1
9	Closed	1
10
11	Start Date
12	Start	1/1/1990
13	End	1/1/2018
14
15	End Date
16	Start	1/1/2010
17	End	1/1/2022
18	State
19	Florida	1
20	Georgia	1
21	Illinois	1
22	New York	1
23	Pennsylvania	1
24	Nevada	1
25
26	Region
27	North	1
28	South	1
29	Midwest	1
30	East	1
31
32	Format
33	na	1
34	Luxury	1
35	Mid-Market	1
36	Affordable	1
37	Mixed	1
38
39	Building Type
40	Res	1
41	Comm	1
42	Federal	1
43
44
45	Size
46	Min	10,000
47	Max	50,000
48
49	Yard Size
50	Min	10,000
51	Max	50,000
52
53	Total Sq Ft
54	Min	10,000
55	Max	50,000
56
57	Current Term Ends
58	Start	1/1/1990
59	End	1/1/2040
60
61	Lease Term
62	Start	1/1/1990
63	End	1/1/2040
64
65	Total Membership Cost
66	Min	$0
67	Max	$50,000
68
69	Switchboard
70
71	Include in Grand Total?
72
73	Member ID	1	2	3	4	5	6
74	Status	Open	Open	Open	Open	Closed	Open
75	Start Date	10/1/1991	2/1/1990	3/1/1991	3/1/1993	11/1/1993	12/1/1993
76	End Date	na	na	na	na	7/23/2018	na
77	State	Florida	New York	Alabama	Florida	Georgia	Illinois
78	Region	South	East	South	South		Midwest
79	Format	na	na	na	na	na	na
80	Building Type	Res	Res	Comm	Res	Federal	Federal
81	Size	5,850	9,000	9,000	9,011	10,800	10,500
82	Yard Size	--	--	990	--	--	--
83	Total Sq Ft	5,850	9,000	9,990	9,011	10,800	10,500
84	Current Term Ends	######	3/31/2020	9/30/2021	5/31/2023	na	6/30/2028
85	Lease Term Date	######	3/31/2025	9/30/2030	5/31/2028	na	6/30/2028
86	Total Membership Costs	10,000	11,000	12,000	13,000	14,000	15,000
xl2bb

Cell Formulas
Range	Formula
C73:G73	C73	=+B73+1
C86:G86	C86	=+B86+1000

 

[BigBeachBananas]

I recommend using a pivot table and slicers. See this.

 

[k3yn0t3]

Unfortunately, I cannot use pivot tables due to the way my workbook is structured.