Do NOT count cell if adjacent cells have a 1

[abrig005]

Hello,
Each cell is either blank or has a 1.
I want to count the number of 1's only if there is not a 1 in any adjacent cell.
For example building 1 would only be counted under Class 2 and not 4 6 and 7
building 13 would only be counted under Class 1 and not Class 6 and 7
Class 1 is a simple count....
Class 2 would only count if there is not a 1 in the adjacent cell in Class 1 etc.

Thank you!!!!!!!!!!!!!!!

 

[mackc557]

I don't know if there is a simpler way, but this is my attempt.

Book1
	A	B	C	D	E	F
1		1	2	4	6	7
2	1		1	1	1	1
3	2			1	1	1
4	3				1	1
5	4				1	1
6	5				1	1
7	6				1	1
8	7				1	1
9	8				1	1
10	9				1	1
11	10				1	1
12	11				1	1
13	12				1	1
14	13	1			1	1
15	14				1	1
16	15				1	1
17	16	1			1	1
18	17				1	1
19	18				1	1
20	19					1
21	20					1
22	21					1
23	22					1
24	23					1
25	24					1
26	25					1
27	26					1
28	27					1
29	28					1
30	29					1
31	30					1
32	31					1
33	32					1
34	33					1
35
36	Count:	2	1	1	14	15
Sheet1

Cell Formulas
Range	Formula
B36	B36	=COUNTIF(B2:B34,1)
C36	C36	=COUNTIFS(C2:C34,1,B2:B34,"<>1")
D36	D36	=COUNTIFS(D2:D34,1,B2:B34,"<>1",C2:C34,"<>1")
E36	E36	=COUNTIFS(E2:E34,1,C2:C34,"<>1",B2:B34,"<>1",D2:D34,"<>1")
F36	F36	=COUNTIFS(F2:F34,1,B2:B34,"<>1",C2:C34,"<>1",E2:E34,"<>1",D2:D34,"<>1")

 

[Fluff]

Office 365

Thanks for that, please don't forget to update you account details to show this.

How about

+Fluff 1.xlsm
	A	B	C	D	E	F
1		1	2	4	6	7
2	1		1	1	1	1
3	2			1	1	1
4	3				1	1
5	4				1	1
6	5				1	1
7	6				1	1
8	7				1	1
9	8				1	1
10	9				1	1
11	10				1	1
12	11				1	1
13	12				1	1
14	13	1			1	1
15	14				1	1
16	15				1	1
17	16	1			1	1
18	17				1	1
19	18				1	1
20	19					1
21	20					1
22	21					1
23	22					1
24	23					1
25	24					1
26	25					1
27	26					1
28	27					1
29	28					1
30	29					1
31	30					1
32	31					1
33	32					1
34	33					1
35
36		2	1	1	14	15
Lists

Cell Formulas
Range	Formula
B36	B36	=SUM(B2:B34)
C36:D36	C36	=SUMIFS(C2:C34,B2:B34,"")
E36	E36	=SUMIFS(E2:E34,B2:B34,"",C2:C34,"",D2:D34,"")
F36	F36	=SUMIFS(F2:F34,B2:B34,"",C2:C34,"",D2:D34,"",E2:E34,"")

 

[abrig005]

that is it thank you very much have a nice weekend!~

 

[Fluff]

Glad we could help & thanks for the feedback.

Thanks also for updating your profile.