Dynamic Array How to Exclude Columns

[Stephen_IV]

I have a dynamic array that I use, I an trying to exclude certain columns but are coming up empty. In this example what if I only wanted Column A,C,D or A,B,D. How would I modify this or what dynamic array formula would allow me to do this?

VBA FWC and BMA Applicants.xlsm A B C D E F 1 School A School B School C School D 2 2 X X X X 3 X 4 X X X 5 X 6 X X X 7 8 X X 9 X X 10 X X X X 11 12 X X X X 13 X 14 X 15 X 16 X X X 17 X X Sheet4 Cell Formulas Range Formula F1 F1 =SUM(--BYROW(A2:D17,LAMBDA(x,COUNTIF(x,"X")=0)))

 

[JGordon11]

Book1
	A	B	C	D	E	F	G
1	School A	School B	School C	School D		Count of Included Schools All <> X
2	X	X	X	X		2	All Schools
3			X			3	Exclude School C
4	X	X	X			5	Exclude Schools B & C
5				X
6	X	X	X
7
8		X		X
9	X	X
10	X	X	X	X
11
12	X	X	X	X
13		X
14	X
15				X
16	X	X		X
17		X	X
Sheet7

Cell Formulas
Range	Formula
F2	F2	=SUM(--(MMULT(--(A2:D17="X"),{1;1;1;1})=0))
F3	F3	=SUM(--(MMULT(--(A2:D17="X"),{1;1;0;1})=0))
F4	F4	=SUM(--(MMULT(--(A2:D17="X"),{1;0;0;1})=0))

 

[Stephen_IV]

Book1
	A	B	C	D	E	F	G
1	School A	School B	School C	School D		Count of Included Schools All <> X
2	X	X	X	X		2	All Schools
3			X			3	Exclude School C
4	X	X	X			5	Exclude Schools B & C
5				X
6	X	X	X
7
8		X		X
9	X	X
10	X	X	X	X
11
12	X	X	X	X
13		X
14	X
15				X
16	X	X		X
17		X	X
Sheet7

Cell Formulas
Range	Formula
F2	F2	=SUM(--(MMULT(--(A2:D17="X"),{1;1;1;1})=0))
F3	F3	=SUM(--(MMULT(--(A2:D17="X"),{1;1;0;1})=0))
F4	F4	=SUM(--(MMULT(--(A2:D17="X"),{1;0;0;1})=0))

Than you very much.