XCOUNT

[Rnkhch]

XCOUNT is a powerful cell counting solution to count 'cells in a range' or 'array elements' or rows/columns in ranges/arrays that contain the specified data type (high resolution) and/or meet 'matching criteria'

XCOUNT was designed to count cells in ranges or elements of arrays or the number of rows/columns in the range/array that contain the precise specified data type, with high resolution. Additionally, matching criteria can be specified to further narrow down the results. Alternatively, XCOUNT can also return the total count excluding all of the specified conditions. Thus, XTYPE can be considered as an AGGREGATE-style function and a powerful alternative to the built-in counting functions such as COUNT and COUNTA while avoiding their occasionally-encountered idiosyncratic ambiguities.

XCOUNT consists of one required parameter and five optional parameters as follows:

A) The first parameter, required, specifies the reference to be analyzed

B) The second parameter, optional, specifies the counting type by determining which precise data type to be counted and takes one of twenty-five arguments:
0 or omitted, for all types
1, for numbers (dt:NUMBER)
2, for texts (dt:TEXT)
3, for blanks (dt:BLANK)
4, for logicals (dt:LOGICAL)
16, for errors (dt:ERROR)
31, for real blanks (dt:BLANK_REAL)
32, for formula blanks (dt:BLANK_FORMULA)
41, for TRUE logicals (dt:LOGICAL_TRUE)
42, for FALSE logicals (dt:LOGICAL_FALSE)
160, for #EXTERNAL! error (dt:ERROR_EXTERNAL!)
161, for #NULL! error (dt:ERROR_NULL!)
162, for #DIV/0! error (dt:ERROR_DIV/0!)
163, for #VALUE! error (dt:ERROR_VALUE!)
164, for #REF! error (dt:ERROR_REF!)
165, for #NAME? error (dt:ERROR_NAME?)
166, for #NUM! error (dt:ERROR_NUM!)
167, for #N/A error (dt:ERROR_N/A)
168, for #GETTING_DATA error (dt:ERROR_GETTING_DATA)
169, for #SPILL! error (dt:ERROR_SPILL!)
1610, for #CONNECT! error (dt:ERROR_CONNECT!)
1611, for #BLOCKED! error (dt:ERROR_BLOCKED!)
1612, for #UNKNOWN! error (dt:ERROR_UNKNOWN!)
1613, for #FIELD! error (dt:ERROR_FIELD!)
1614, for #CALC! error (dt:ERROR_CALC!)

C) The third parameter, optional, specifies whether to return the count of rows (rather than cells) that meet the specified parameters and takes one of two arguments:
0 or omitted, for "off" (i.e. rows count not considered)
1, for "on" (i.e. rows count rather than cell count will be considered)

D) The fourth parameter, optional, specifies whether to return the count of columns (rather than cells) that meet the specified parameters and takes one of two arguments:
0 or omitted, for "off" (i.e. columns count not considered)
1, for "on" (i.e. columns count rather than cell count will be considered)

Note that both the rows and columns parameters cannot be used simultaneously.

E) The fifth parameter, optional, specifies any additional desired match criteria to be included during counting to further narrow down the output

F) The sixth parameter, optional, specifies whether the "total count excluding the count obtained through all the specified criteria" will be returned and takes one of two arguments:
0 or omitted, for "off" (i.e. the count obtained by the previous parameters will be returned)
1, for "on" (i.e. the total count minus the count obtained by the previous parameters will be returned)

xcount.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U
1
2			#CALC!																basic types
3																			1	dt:NUMBER
4			46	#N/A	94	76	book	70	82	TRUE	68		49	36		27	54		2	dt:TEXT
5			71	42	37	47	56	35	#DIV/0!	90	63	86	13	86	67	76	#CALC!		3	dt:BLANK
6			92	32	83	63	21	92	31	33	77	a	57	FALSE	16	41	64		4	dt:LOGICAL
7																			16	dt:ERROR
8		no match criteria
9																			advanced types
10			count type omitted			count type = 0			count type = 1			count type = 2			count type = 3				1	dt:NUMBER
11			all			all			all			all			all				2	dt:TEXT
12			cells	45		cells	45		cells	36		cells	2		cells	2			31	dt:BLANK_REAL
13			rows	3		rows	3		rows	3		rows	2		rows	1			32	dt:BLANK_FORMULA
14			columns	15		columns	15		columns	15		columns	2		columns	2			41	dt:LOGICAL_TRUE
15			excluding			excluding			excluding			excluding			excluding				42	dt:LOGICAL_FALSE
16			cells	0		cells	0		cells	9		cells	43		cells	43			160	dt:ERROR_EXTERNAL!
17			rows	0		rows	0		rows	0		rows	1		rows	2			161	dt:ERROR_NULL!
18			columns	0		columns	0		columns	0		columns	13		columns	13			162	dt:ERROR_DIV/0!
19																			163	dt:ERROR_VALUE!
20			count type = 4			count type = 16			count type = 31			count type = 32			count type = 41				164	dt:ERROR_REF!
21			all			all			all			all			all				165	dt:ERROR_NAME?
22			cells	2		cells	3		cells	1		cells	1		cells	1			166	dt:ERROR_NUM!
23			rows	2		rows	2		rows	1		rows	1		rows	1			167	dt:ERROR_N/A!
24			columns	2		columns	3		columns	1		columns	1		columns	1			168	dt:ERROR_GETTING_DATA!
25			excluding			excluding			excluding			excluding			excluding				169	dt:ERROR_SPILL!
26			cells	43		cells	42		cells	44		cells	44		cells	44			1610	dt:ERROR_CONNECT!
27			rows	1		rows	1		rows	2		rows	2		rows	2			1611	dt:ERROR_BLOCKED!
28			columns	13		columns	12		columns	14		columns	14		columns	14			1612	dt:ERROR_UNKNOWN!
29																			1613	dt:ERROR_FIELD!
30			count type = 42			count type = 160			count type = 161			count type = 162			count type = 163				1614	dt:ERROR_CALC!
31			all			all			all			all			all
32			cells	1		cells	0		cells	0		cells	1		cells	0
33			rows	1		rows	0		rows	0		rows	1		rows	0
34			columns	1		columns	0		columns	0		columns	1		columns	0
35			excluding			excluding			excluding			excluding			excluding
36			cells	44		cells	45		cells	45		cells	44		cells	45
37			rows	2		rows	3		rows	3		rows	2		rows	3
38			columns	14		columns	15		columns	15		columns	14		columns	15
39
40			count type = 164			count type = 165			count type = 166			count type = 167			count type = 168
41			all			all			all			all			all
42			cells	0		cells	0		cells	0		cells	1		cells	0
43			rows	0		rows	0		rows	0		rows	1		rows	0
44			columns	0		columns	0		columns	0		columns	1		columns	0
45			excluding			excluding			excluding			excluding			excluding
46			cells	45		cells	45		cells	45		cells	44		cells	45
47			rows	3		rows	3		rows	3		rows	2		rows	3
48			columns	15		columns	15		columns	15		columns	14		columns	15
49
50			count type = 169			count type = 1610			count type = 1611			count type = 1612			count type = 1613
51			all			all			all			all			all
52			cells	0		cells	0		cells	0		cells	0		cells	0
53			rows	0		rows	0		rows	0		rows	0		rows	0
54			columns	0		columns	0		columns	0		columns	0		columns	0
55			excluding			excluding			excluding			excluding			excluding
56			cells	45		cells	45		cells	45		cells	45		cells	45
57			rows	3		rows	3		rows	3		rows	3		rows	3
58			columns	15		columns	15		columns	15		columns	15		columns	15
59
60			count type = 1614
61			all
62			cells	1
63			rows	1
64			columns	1
65			excluding
66			cells	44
67			rows	2
68			columns	14
69
70
Sheet3

Cell Formulas
Range	Formula
C2	C2	=LAMBDA(reference,[count_type],[rows],[columns],[match_criteria],[total_excluding],LET(ref,reference,ct,count_type,tet,total_excluding,rs,rows,cs,columns,mtc,IFERROR(match_criteria,0),IF(OR(IF(AND(NIO(count_type),ct<>0),ISERROR(MATCH(ct,AllTypes,0))),IF(NIO(total_excluding),ISERROR(MATCH(tet,{0,1},0))),IF(NIO(rows),ISERROR(MATCH(rs,{0,1},0))),IF(NIO(columns),ISERROR(MATCH(cs,{0,1},0))),AND(rs=1,cs=1),AND(OR(IO(count_type),ct=0),NIO(match_criteria))),XERROR(7),IF(AND(OR(IO(rows),rs=0),OR(IO(columns),cs=0)),LET(t,COLUMNS(ref)*ROWS(ref),exp,IF(OR(IO(count_type),ct=0),t,IF(AND(ct>=1,ct<=16),SUM(ISXTYPE(ref,ct,,mtc,1)),SUM(ISXTYPE(ref,,ct,mtc,1)))),IF(OR(IO(total_excluding),tet=0),exp,t-exp)),IF(AND(OR(IO(columns),cs=0),rs=1),LET(tr,ROWS(ref),IF(OR(IO(count_type),ct=0),IF(OR(IO(total_excluding),tet=0),tr,0),LET(a,IF(ct<=16,ISXTYPE(ref,ct,,mtc,1),ISXTYPE(ref,,ct,mtc,1)),rexp,SUM(IF(MMULT(a,SEQUENCE(COLUMNS(a),,1,0)),1,0)),IF(OR(IO(total_excluding),tet=0),rexp,tr-rexp)))),IF(AND(OR(IO(rows),rs=0),cs=1),IF(OR(IO(count_type),ct=0),IF(OR(IO(total_excluding),tet=0),COLUMNS(ref),0),LET(tref,TRANSPOSE(ref),tr,ROWS(tref),tmtc,TRANSPOSE(mtc),a,IF(ct<=16,IF(IO(match_criteria),ISXTYPE(tref,ct,,,1),ISXTYPE(tref,ct,,tmtc,1)),IF(IO(match_criteria),ISXTYPE(tref,,ct,,1),ISXTYPE(tref,,ct,tmtc,1))),rexp,SUM(IF(MMULT(a,SEQUENCE(COLUMNS(a),,1,0)),1,0)),IF(OR(IO(total_excluding),tet=0),rexp,tr-rexp)))))))))
D4	D4	=XERROR(7)
L4	L4	=IF(1,"")
I5	I5	=1/0
Q5	Q5	=XERROR(14)
D12	D12	=XCOUNT($C$4:$Q$6)
D13	D13	=XCOUNT($C$4:$Q$6,,1)
D14	D14	=XCOUNT($C$4:$Q$6,,,1)
G12	G12	=XCOUNT($C$4:$Q$6,0)
G13	G13	=XCOUNT($C$4:$Q$6,0,1)
G14	G14	=XCOUNT($C$4:$Q$6,0,,1)
J12	J12	=XCOUNT($C$4:$Q$6,1)
J13	J13	=XCOUNT($C$4:$Q$6,1,1)
J14	J14	=XCOUNT($C$4:$Q$6,1,,1)
M12	M12	=XCOUNT($C$4:$Q$6,2)
M13	M13	=XCOUNT($C$4:$Q$6,2,1)
M14	M14	=XCOUNT($C$4:$Q$6,2,,1)
P12	P12	=XCOUNT($C$4:$Q$6,3)
P13	P13	=XCOUNT($C$4:$Q$6,3,1)
P14	P14	=XCOUNT($C$4:$Q$6,3,,1)
D16	D16	=XCOUNT($C$4:$Q$6,,,,,1)
D17	D17	=XCOUNT($C$4:$Q$6,,1,,,1)
D18	D18	=XCOUNT($C$4:$Q$6,,,1,,1)
G16	G16	=XCOUNT($C$4:$Q$6,0,,,,1)
G17	G17	=XCOUNT($C$4:$Q$6,0,1,,,1)
G18	G18	=XCOUNT($C$4:$Q$6,0,,1,,1)
J16	J16	=XCOUNT($C$4:$Q$6,1,,,,1)
J17	J17	=XCOUNT($C$4:$Q$6,1,1,,,1)
J18	J18	=XCOUNT($C$4:$Q$6,1,,1,,1)
M16	M16	=XCOUNT($C$4:$Q$6,2,,,,1)
M17	M17	=XCOUNT($C$4:$Q$6,2,1,,,1)
M18	M18	=XCOUNT($C$4:$Q$6,2,,1,,1)
P16	P16	=XCOUNT($C$4:$Q$6,3,,,,1)
P17	P17	=XCOUNT($C$4:$Q$6,3,1,,,1)
P18	P18	=XCOUNT($C$4:$Q$6,3,,1,,1)
D22	D22	=XCOUNT($C$4:$Q$6,4)
D23	D23	=XCOUNT($C$4:$Q$6,4,1)
D24	D24	=XCOUNT($C$4:$Q$6,4,,1)
G22	G22	=XCOUNT($C$4:$Q$6,16)
G23	G23	=XCOUNT($C$4:$Q$6,16,1)
G24	G24	=XCOUNT($C$4:$Q$6,16,,1)
J22	J22	=XCOUNT($C$4:$Q$6,31)
J23	J23	=XCOUNT($C$4:$Q$6,31,1)
J24	J24	=XCOUNT($C$4:$Q$6,31,,1)
M22	M22	=XCOUNT($C$4:$Q$6,32)
M23	M23	=XCOUNT($C$4:$Q$6,32,1)
M24	M24	=XCOUNT($C$4:$Q$6,32,,1)
P22	P22	=XCOUNT($C$4:$Q$6,41)
P23	P23	=XCOUNT($C$4:$Q$6,41,1)
P24	P24	=XCOUNT($C$4:$Q$6,41,,1)
D26	D26	=XCOUNT($C$4:$Q$6,4,,,,1)
D27	D27	=XCOUNT($C$4:$Q$6,4,1,,,1)
D28	D28	=XCOUNT($C$4:$Q$6,4,,1,,1)
G26	G26	=XCOUNT($C$4:$Q$6,16,,,,1)
G27	G27	=XCOUNT($C$4:$Q$6,16,1,,,1)
G28	G28	=XCOUNT($C$4:$Q$6,16,,1,,1)
J26	J26	=XCOUNT($C$4:$Q$6,31,,,,1)
J27	J27	=XCOUNT($C$4:$Q$6,31,1,,,1)
J28	J28	=XCOUNT($C$4:$Q$6,31,,1,,1)
M26	M26	=XCOUNT($C$4:$Q$6,32,,,,1)
M27	M27	=XCOUNT($C$4:$Q$6,32,1,,,1)
M28	M28	=XCOUNT($C$4:$Q$6,32,,1,,1)
P26	P26	=XCOUNT($C$4:$Q$6,41,,,,1)
P27	P27	=XCOUNT($C$4:$Q$6,41,1,,,1)
P28	P28	=XCOUNT($C$4:$Q$6,41,,1,,1)
D32	D32	=XCOUNT($C$4:$Q$6,42)
D33	D33	=XCOUNT($C$4:$Q$6,42,1)
D34	D34	=XCOUNT($C$4:$Q$6,42,,1)
G32	G32	=XCOUNT($C$4:$Q$6,160)
G33	G33	=XCOUNT($C$4:$Q$6,160,1)
G34	G34	=XCOUNT($C$4:$Q$6,160,,1)
J32	J32	=XCOUNT($C$4:$Q$6,161)
J33	J33	=XCOUNT($C$4:$Q$6,161,1)
J34	J34	=XCOUNT($C$4:$Q$6,161,,1)
M32	M32	=XCOUNT($C$4:$Q$6,162)
M33	M33	=XCOUNT($C$4:$Q$6,162,1)
M34	M34	=XCOUNT($C$4:$Q$6,162,,1)
P32	P32	=XCOUNT($C$4:$Q$6,163)
P33	P33	=XCOUNT($C$4:$Q$6,163,1)
P34	P34	=XCOUNT($C$4:$Q$6,163,,1)
D36	D36	=XCOUNT($C$4:$Q$6,42,,,,1)
D37	D37	=XCOUNT($C$4:$Q$6,42,1,,,1)
D38	D38	=XCOUNT($C$4:$Q$6,42,,1,,1)
G36	G36	=XCOUNT($C$4:$Q$6,160,,,,1)
G37	G37	=XCOUNT($C$4:$Q$6,160,1,,,1)
G38	G38	=XCOUNT($C$4:$Q$6,160,,1,,1)
J36	J36	=XCOUNT($C$4:$Q$6,161,,,,1)
J37	J37	=XCOUNT($C$4:$Q$6,161,1,,,1)
J38	J38	=XCOUNT($C$4:$Q$6,161,,1,,1)
M36	M36	=XCOUNT($C$4:$Q$6,162,,,,1)
M37	M37	=XCOUNT($C$4:$Q$6,162,1,,,1)
M38	M38	=XCOUNT($C$4:$Q$6,162,,1,,1)
P36	P36	=XCOUNT($C$4:$Q$6,163,,,,1)
P37	P37	=XCOUNT($C$4:$Q$6,163,1,,,1)
P38	P38	=XCOUNT($C$4:$Q$6,163,,1,,1)
D42	D42	=XCOUNT($C$4:$Q$6,164)
D43	D43	=XCOUNT($C$4:$Q$6,164,1)
D44	D44	=XCOUNT($C$4:$Q$6,164,,1)
G42	G42	=XCOUNT($C$4:$Q$6,165)
G43	G43	=XCOUNT($C$4:$Q$6,165,1)
G44	G44	=XCOUNT($C$4:$Q$6,165,,1)
J42	J42	=XCOUNT($C$4:$Q$6,166)
J43	J43	=XCOUNT($C$4:$Q$6,166,1)
J44	J44	=XCOUNT($C$4:$Q$6,166,,1)
M42	M42	=XCOUNT($C$4:$Q$6,167)
M43	M43	=XCOUNT($C$4:$Q$6,167,1)
M44	M44	=XCOUNT($C$4:$Q$6,167,,1)
P42	P42	=XCOUNT($C$4:$Q$6,168)
P43	P43	=XCOUNT($C$4:$Q$6,168,1)
P44	P44	=XCOUNT($C$4:$Q$6,168,,1)
D46	D46	=XCOUNT($C$4:$Q$6,164,,,,1)
D47	D47	=XCOUNT($C$4:$Q$6,164,1,,,1)
D48	D48	=XCOUNT($C$4:$Q$6,164,,1,,1)
G46	G46	=XCOUNT($C$4:$Q$6,165,,,,1)
G47	G47	=XCOUNT($C$4:$Q$6,165,1,,,1)
G48	G48	=XCOUNT($C$4:$Q$6,165,,1,,1)
J46	J46	=XCOUNT($C$4:$Q$6,166,,,,1)
J47	J47	=XCOUNT($C$4:$Q$6,166,1,,,1)
J48	J48	=XCOUNT($C$4:$Q$6,166,,1,,1)
M46	M46	=XCOUNT($C$4:$Q$6,167,,,,1)
M47	M47	=XCOUNT($C$4:$Q$6,167,1,,,1)
M48	M48	=XCOUNT($C$4:$Q$6,167,,1,,1)
P46	P46	=XCOUNT($C$4:$Q$6,168,,,,1)
P47	P47	=XCOUNT($C$4:$Q$6,168,1,,,1)
P48	P48	=XCOUNT($C$4:$Q$6,168,,1,,1)
D52	D52	=XCOUNT($C$4:$Q$6,169)
D53	D53	=XCOUNT($C$4:$Q$6,169,1)
D54	D54	=XCOUNT($C$4:$Q$6,169,,1)
G52	G52	=XCOUNT($C$4:$Q$6,1610)
G53	G53	=XCOUNT($C$4:$Q$6,1610,1)
G54	G54	=XCOUNT($C$4:$Q$6,1610,,1)
J52	J52	=XCOUNT($C$4:$Q$6,1611)
J53	J53	=XCOUNT($C$4:$Q$6,1611,1)
J54	J54	=XCOUNT($C$4:$Q$6,1611,,1)
M52	M52	=XCOUNT($C$4:$Q$6,1612)
M53	M53	=XCOUNT($C$4:$Q$6,1612,1)
M54	M54	=XCOUNT($C$4:$Q$6,1612,,1)
P52	P52	=XCOUNT($C$4:$Q$6,1613)
P53	P53	=XCOUNT($C$4:$Q$6,1613,1)
P54	P54	=XCOUNT($C$4:$Q$6,1613,,1)
D56	D56	=XCOUNT($C$4:$Q$6,169,,,,1)
D57	D57	=XCOUNT($C$4:$Q$6,169,1,,,1)
D58	D58	=XCOUNT($C$4:$Q$6,169,,1,,1)
G56	G56	=XCOUNT($C$4:$Q$6,1610,,,,1)
G57	G57	=XCOUNT($C$4:$Q$6,1610,1,,,1)
G58	G58	=XCOUNT($C$4:$Q$6,1610,,1,,1)
J56	J56	=XCOUNT($C$4:$Q$6,1611,,,,1)
J57	J57	=XCOUNT($C$4:$Q$6,1611,1,,,1)
J58	J58	=XCOUNT($C$4:$Q$6,1611,,1,,1)
M56	M56	=XCOUNT($C$4:$Q$6,1612,,,,1)
M57	M57	=XCOUNT($C$4:$Q$6,1612,1,,,1)
M58	M58	=XCOUNT($C$4:$Q$6,1612,,1,,1)
P56	P56	=XCOUNT($C$4:$Q$6,1613,,,,1)
P57	P57	=XCOUNT($C$4:$Q$6,1613,1,,,1)
P58	P58	=XCOUNT($C$4:$Q$6,1613,,1,,1)
D62	D62	=XCOUNT($C$4:$Q$6,1614)
D63	D63	=XCOUNT($C$4:$Q$6,1614,1)
D64	D64	=XCOUNT($C$4:$Q$6,1614,,1)
D66	D66	=XCOUNT($C$4:$Q$6,1614,,,,1)
D67	D67	=XCOUNT($C$4:$Q$6,1614,1,,,1)
D68	D68	=XCOUNT($C$4:$Q$6,1614,,1,,1)

Please feel free to share any thoughts or suggestions.

 

[Rnkhch]

Apologies, the code was not included in the original post:

=LAMBDA(reference,[count_type],[rows],[columns],[match_criteria],[total_excluding],
   LET(
      ref,reference,
      ct,count_type,
      tet,total_excluding,
      rs,rows,
      cs,columns,
      mtc,IFERROR(match_criteria,0),
         IF(OR(IF(AND(NIO(count_type),ct<>0),ISERROR(MATCH(ct,AllTypes,0))),IF(NIO(total_excluding),ISERROR(MATCH(tet,{0,1},0))),IF(NIO(rows),ISERROR(MATCH(rs,{0,1},0))),IF(NIO(columns),ISERROR(MATCH(cs,{0,1},0))),AND(rs=1,cs=1),AND(OR(IO(count_type),ct=0),NIO(match_criteria))),
         XERROR(7),
            IF(AND(OR(IO(rows),rs=0),OR(IO(columns),cs=0)),
               LET(
                  t,COLUMNS(ref)*ROWS(ref),
                  exp,IF(OR(IO(count_type),ct=0),t,IF(AND(ct>=1,ct<=16),SUM(ISXTYPE(ref,ct,,mtc,1)),SUM(ISXTYPE(ref,,ct,mtc,1)))),
                     IF(OR(IO(total_excluding),tet=0),exp,t-exp)),IF(AND(OR(IO(columns),cs=0),rs=1),
                        LET(
                           tr,ROWS(ref),
                           IF(OR(IO(count_type),ct=0),IF(OR(IO(total_excluding),tet=0),tr,0),LET(a,IF(ct<=16,ISXTYPE(ref,ct,,mtc,1),ISXTYPE(ref,,ct,mtc,1)),rexp,SUM(IF(MMULT(a,SEQUENCE(COLUMNS(a),,1,0)),1,0)),IF(OR(IO(total_excluding),tet=0),rexp,tr-rexp)))),
                              IF(AND(OR(IO(rows),rs=0),cs=1),
                                 IF(OR(IO(count_type),ct=0),
                                    IF(OR(IO(total_excluding),tet=0),COLUMNS(ref),0),
                                       LET(
                                          tref,TRANSPOSE(ref),
                                          tr,ROWS(tref),
                                          tmtc,TRANSPOSE(mtc),
                                          a,IF(ct<=16,IF(IO(match_criteria),ISXTYPE(tref,ct,,,1),ISXTYPE(tref,ct,,tmtc,1)),IF(IO(match_criteria),ISXTYPE(tref,,ct,,1),ISXTYPE(tref,,ct,tmtc,1))),
                                          rexp,SUM(IF(MMULT(a,SEQUENCE(COLUMNS(a),,1,0)),1,0)),
                                             IF(OR(IO(total_excluding),tet=0),
                                                rexp,
                                                tr-rexp)
                                       )
                                    )
                                 )
                              )
            )
         )
   )
)

The following helper LAMBDAs and defined name are used in this code:

ISXTYPE() which is posted

XERROR() which is posted

IO

=LAMBDA(parameter,ISOMITTED(parameter))

NIO

=LAMBDA(parameter,NOT(ISOMITTED(parameter)))

AllTypes

={1,2,3,4,16,31,32,41,42,160,161,162,163,164,165,166,167,168,169,1610,1611,1612,1613,1614}

 

[Rnkhch]

(The following examples didn't fit the original post as the total character count of the post exceeded 100,000)

Here are a few examples for match_criteria included; the first XL2BB for numbers and the second for texts:

xcount.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R
70
71		match criteria for numbers
72
73			count type omitted			count type = 0			count type = 1			count type = 2			count type = 3
74			all			all			all			all			all
75			cells	#N/A		cells	#N/A		cells	1		cells	0		cells	0
76			rows	#N/A		rows	#N/A		rows	1		rows	0		rows	0
77			columns	#N/A		columns	#N/A		columns	1		columns	0		columns	0
78			excluding			excluding			excluding			excluding			excluding
79			cells	#N/A		cells	#N/A		cells	44		cells	45		cells	45
80			rows	#N/A		rows	#N/A		rows	2		rows	3		rows	3
81			columns	#N/A		columns	#N/A		columns	14		columns	15		columns	15
82
83			count type = 4			count type = 16			count type = 31			count type = 32			count type = 41
84			all			all			all			all			all
85			cells	0		cells	0		cells	0		cells	0		cells	0
86			rows	0		rows	0		rows	0		rows	0		rows	0
87			columns	0		columns	0		columns	0		columns	0		columns	0
88			excluding			excluding			excluding			excluding			excluding
89			cells	45		cells	45		cells	45		cells	45		cells	45
90			rows	3		rows	3		rows	3		rows	3		rows	3
91			columns	15		columns	15		columns	15		columns	15		columns	15
92
93			count type = 42			count type = 160			count type = 161			count type = 162			count type = 163
94			all			all			all			all			all
95			cells	0		cells	0		cells	0		cells	0		cells	0
96			rows	0		rows	0		rows	0		rows	0		rows	0
97			columns	0		columns	0		columns	0		columns	0		columns	0
98			excluding			excluding			excluding			excluding			excluding
99			cells	45		cells	45		cells	45		cells	45		cells	45
100			rows	3		rows	3		rows	3		rows	3		rows	3
101			columns	15		columns	15		columns	15		columns	15		columns	15
102
103			count type = 164			count type = 165			count type = 166			count type = 167			count type = 168
104			all			all			all			all			all
105			cells	0		cells	0		cells	0		cells	0		cells	0
106			rows	0		rows	0		rows	0		rows	0		rows	0
107			columns	0		columns	0		columns	0		columns	0		columns	0
108			excluding			excluding			excluding			excluding			excluding
109			cells	45		cells	45		cells	45		cells	45		cells	45
110			rows	3		rows	3		rows	3		rows	3		rows	3
111			columns	15		columns	15		columns	15		columns	15		columns	15
112
113			count type = 169			count type = 1610			count type = 1611			count type = 1612			count type = 1613
114			all			all			all			all			all
115			cells	0		cells	0		cells	0		cells	0		cells	0
116			rows	0		rows	0		rows	0		rows	0		rows	0
117			columns	0		columns	0		columns	0		columns	0		columns	0
118			excluding			excluding			excluding			excluding			excluding
119			cells	45		cells	45		cells	45		cells	45		cells	45
120			rows	3		rows	3		rows	3		rows	3		rows	3
121			columns	15		columns	15		columns	15		columns	15		columns	15
122
123			count type = 1614
124			all
125			cells	0
126			rows	0
127			columns	0
128			excluding
129			cells	45
130			rows	3
131			columns	15
132
133
Sheet3

Cell Formulas
Range	Formula
D75	D75	=XCOUNT($C$4:$Q$6,,,,$C$4:$Q$6=90)
D76	D76	=XCOUNT($C$4:$Q$6,,1,,$C$4:$Q$6=90)
D77	D77	=XCOUNT($C$4:$Q$6,,,1,$C$4:$Q$6=90)
G75	G75	=XCOUNT($C$4:$Q$6,0,,,$C$4:$Q$6=90)
G76	G76	=XCOUNT($C$4:$Q$6,0,1,,$C$4:$Q$6=90)
G77	G77	=XCOUNT($C$4:$Q$6,0,,1,$C$4:$Q$6=90)
J75	J75	=XCOUNT($C$4:$Q$6,1,,,$C$4:$Q$6=90)
J76	J76	=XCOUNT($C$4:$Q$6,1,1,,$C$4:$Q$6=90)
J77	J77	=XCOUNT($C$4:$Q$6,1,,1,$C$4:$Q$6=90)
M75	M75	=XCOUNT($C$4:$Q$6,2,,,$C$4:$Q$6=90)
M76	M76	=XCOUNT($C$4:$Q$6,2,1,,$C$4:$Q$6=90)
M77	M77	=XCOUNT($C$4:$Q$6,2,,1,$C$4:$Q$6=90)
P75	P75	=XCOUNT($C$4:$Q$6,3,,,$C$4:$Q$6=90)
P76	P76	=XCOUNT($C$4:$Q$6,3,1,,$C$4:$Q$6=90)
P77	P77	=XCOUNT($C$4:$Q$6,3,,1,$C$4:$Q$6=90)
D79	D79	=XCOUNT($C$4:$Q$6,,,,$C$4:$Q$6=90,1)
D80	D80	=XCOUNT($C$4:$Q$6,,1,,$C$4:$Q$6=90,1)
D81	D81	=XCOUNT($C$4:$Q$6,,,1,$C$4:$Q$6=90,1)
G79	G79	=XCOUNT($C$4:$Q$6,0,,,$C$4:$Q$6=90,1)
G80	G80	=XCOUNT($C$4:$Q$6,0,1,,$C$4:$Q$6=90,1)
G81	G81	=XCOUNT($C$4:$Q$6,0,,1,$C$4:$Q$6=90,1)
J79	J79	=XCOUNT($C$4:$Q$6,1,,,$C$4:$Q$6=90,1)
J80	J80	=XCOUNT($C$4:$Q$6,1,1,,$C$4:$Q$6=90,1)
J81	J81	=XCOUNT($C$4:$Q$6,1,,1,$C$4:$Q$6=90,1)
M79	M79	=XCOUNT($C$4:$Q$6,2,,,$C$4:$Q$6=90,1)
M80	M80	=XCOUNT($C$4:$Q$6,2,1,,$C$4:$Q$6=90,1)
M81	M81	=XCOUNT($C$4:$Q$6,2,,1,$C$4:$Q$6=90,1)
P79	P79	=XCOUNT($C$4:$Q$6,3,,,$C$4:$Q$6=90,1)
P80	P80	=XCOUNT($C$4:$Q$6,3,1,,$C$4:$Q$6=90,1)
P81	P81	=XCOUNT($C$4:$Q$6,3,,1,$C$4:$Q$6=90,1)
D85	D85	=XCOUNT($C$4:$Q$6,4,,,$C$4:$Q$6=90)
D86	D86	=XCOUNT($C$4:$Q$6,4,1,,$C$4:$Q$6=90)
D87	D87	=XCOUNT($C$4:$Q$6,4,,1,$C$4:$Q$6=90)
G85	G85	=XCOUNT($C$4:$Q$6,16,,,$C$4:$Q$6=90)
G86	G86	=XCOUNT($C$4:$Q$6,16,1,,$C$4:$Q$6=90)
G87	G87	=XCOUNT($C$4:$Q$6,16,,1,$C$4:$Q$6=90)
J85	J85	=XCOUNT($C$4:$Q$6,31,,,$C$4:$Q$6=90)
J86	J86	=XCOUNT($C$4:$Q$6,31,1,,$C$4:$Q$6=90)
J87	J87	=XCOUNT($C$4:$Q$6,31,,1,$C$4:$Q$6=90)
M85	M85	=XCOUNT($C$4:$Q$6,32,,,$C$4:$Q$6=90)
M86	M86	=XCOUNT($C$4:$Q$6,32,1,,$C$4:$Q$6=90)
M87	M87	=XCOUNT($C$4:$Q$6,32,,1,$C$4:$Q$6=90)
P85	P85	=XCOUNT($C$4:$Q$6,41,,,$C$4:$Q$6=90)
P86	P86	=XCOUNT($C$4:$Q$6,41,1,,$C$4:$Q$6=90)
P87	P87	=XCOUNT($C$4:$Q$6,41,,1,$C$4:$Q$6=90)
D89	D89	=XCOUNT($C$4:$Q$6,4,,,$C$4:$Q$6=90,1)
D90	D90	=XCOUNT($C$4:$Q$6,4,1,,$C$4:$Q$6=90,1)
D91	D91	=XCOUNT($C$4:$Q$6,4,,1,$C$4:$Q$6=90,1)
G89	G89	=XCOUNT($C$4:$Q$6,16,,,$C$4:$Q$6=90,1)
G90	G90	=XCOUNT($C$4:$Q$6,16,1,,$C$4:$Q$6=90,1)
G91	G91	=XCOUNT($C$4:$Q$6,16,,1,$C$4:$Q$6=90,1)
J89	J89	=XCOUNT($C$4:$Q$6,31,,,$C$4:$Q$6=90,1)
J90	J90	=XCOUNT($C$4:$Q$6,31,1,,$C$4:$Q$6=90,1)
J91	J91	=XCOUNT($C$4:$Q$6,31,,1,$C$4:$Q$6=90,1)
M89	M89	=XCOUNT($C$4:$Q$6,32,,,$C$4:$Q$6=90,1)
M90	M90	=XCOUNT($C$4:$Q$6,32,1,,$C$4:$Q$6=90,1)
M91	M91	=XCOUNT($C$4:$Q$6,32,,1,$C$4:$Q$6=90,1)
P89	P89	=XCOUNT($C$4:$Q$6,41,,,$C$4:$Q$6=90,1)
P90	P90	=XCOUNT($C$4:$Q$6,41,1,,$C$4:$Q$6=90,1)
P91	P91	=XCOUNT($C$4:$Q$6,41,,1,$C$4:$Q$6=90,1)
D95	D95	=XCOUNT($C$4:$Q$6,42,,,$C$4:$Q$6=90)
D96	D96	=XCOUNT($C$4:$Q$6,42,1,,$C$4:$Q$6=90)
D97	D97	=XCOUNT($C$4:$Q$6,42,,1,$C$4:$Q$6=90)
G95	G95	=XCOUNT($C$4:$Q$6,160,,,$C$4:$Q$6=90)
G96	G96	=XCOUNT($C$4:$Q$6,160,1,,$C$4:$Q$6=90)
G97	G97	=XCOUNT($C$4:$Q$6,160,,1,$C$4:$Q$6=90)
J95	J95	=XCOUNT($C$4:$Q$6,161,,,$C$4:$Q$6=90)
J96	J96	=XCOUNT($C$4:$Q$6,161,1,,$C$4:$Q$6=90)
J97	J97	=XCOUNT($C$4:$Q$6,161,,1,$C$4:$Q$6=90)
M95	M95	=XCOUNT($C$4:$Q$6,162,,,$C$4:$Q$6=90)
M96	M96	=XCOUNT($C$4:$Q$6,162,1,,$C$4:$Q$6=90)
M97	M97	=XCOUNT($C$4:$Q$6,162,,1,$C$4:$Q$6=90)
P95	P95	=XCOUNT($C$4:$Q$6,163,,,$C$4:$Q$6=90)
P96	P96	=XCOUNT($C$4:$Q$6,163,1,,$C$4:$Q$6=90)
P97	P97	=XCOUNT($C$4:$Q$6,163,,1,$C$4:$Q$6=90)
D99	D99	=XCOUNT($C$4:$Q$6,42,,,$C$4:$Q$6=90,1)
D100	D100	=XCOUNT($C$4:$Q$6,42,1,,$C$4:$Q$6=90,1)
D101	D101	=XCOUNT($C$4:$Q$6,42,,1,$C$4:$Q$6=90,1)
G99	G99	=XCOUNT($C$4:$Q$6,160,,,$C$4:$Q$6=90,1)
G100	G100	=XCOUNT($C$4:$Q$6,160,1,,$C$4:$Q$6=90,1)
G101	G101	=XCOUNT($C$4:$Q$6,160,,1,$C$4:$Q$6=90,1)
J99	J99	=XCOUNT($C$4:$Q$6,161,,,$C$4:$Q$6=90,1)
J100	J100	=XCOUNT($C$4:$Q$6,161,1,,$C$4:$Q$6=90,1)
J101	J101	=XCOUNT($C$4:$Q$6,161,,1,$C$4:$Q$6=90,1)
M99	M99	=XCOUNT($C$4:$Q$6,162,,,$C$4:$Q$6=90,1)
M100	M100	=XCOUNT($C$4:$Q$6,162,1,,$C$4:$Q$6=90,1)
M101	M101	=XCOUNT($C$4:$Q$6,162,,1,$C$4:$Q$6=90,1)
P99	P99	=XCOUNT($C$4:$Q$6,163,,,$C$4:$Q$6=90,1)
P100	P100	=XCOUNT($C$4:$Q$6,163,1,,$C$4:$Q$6=90,1)
P101	P101	=XCOUNT($C$4:$Q$6,163,,1,$C$4:$Q$6=90,1)
D105	D105	=XCOUNT($C$4:$Q$6,164,,,$C$4:$Q$6=90)
D106	D106	=XCOUNT($C$4:$Q$6,164,1,,$C$4:$Q$6=90)
D107	D107	=XCOUNT($C$4:$Q$6,164,,1,$C$4:$Q$6=90)
G105	G105	=XCOUNT($C$4:$Q$6,165,,,$C$4:$Q$6=90)
G106	G106	=XCOUNT($C$4:$Q$6,165,1,,$C$4:$Q$6=90)
G107	G107	=XCOUNT($C$4:$Q$6,165,,1,$C$4:$Q$6=90)
J105	J105	=XCOUNT($C$4:$Q$6,166,,,$C$4:$Q$6=90)
J106	J106	=XCOUNT($C$4:$Q$6,166,1,,$C$4:$Q$6=90)
J107	J107	=XCOUNT($C$4:$Q$6,166,,1,$C$4:$Q$6=90)
M105	M105	=XCOUNT($C$4:$Q$6,167,,,$C$4:$Q$6=90)
M106	M106	=XCOUNT($C$4:$Q$6,167,1,,$C$4:$Q$6=90)
M107	M107	=XCOUNT($C$4:$Q$6,167,,1,$C$4:$Q$6=90)
P105	P105	=XCOUNT($C$4:$Q$6,168,,,$C$4:$Q$6=90)
P106	P106	=XCOUNT($C$4:$Q$6,168,1,,$C$4:$Q$6=90)
P107	P107	=XCOUNT($C$4:$Q$6,168,,1,$C$4:$Q$6=90)
D109	D109	=XCOUNT($C$4:$Q$6,164,,,$C$4:$Q$6=90,1)
D110	D110	=XCOUNT($C$4:$Q$6,164,1,,$C$4:$Q$6=90,1)
D111	D111	=XCOUNT($C$4:$Q$6,164,,1,$C$4:$Q$6=90,1)
G109	G109	=XCOUNT($C$4:$Q$6,165,,,$C$4:$Q$6=90,1)
G110	G110	=XCOUNT($C$4:$Q$6,165,1,,$C$4:$Q$6=90,1)
G111	G111	=XCOUNT($C$4:$Q$6,165,,1,$C$4:$Q$6=90,1)
J109	J109	=XCOUNT($C$4:$Q$6,166,,,$C$4:$Q$6=90,1)
J110	J110	=XCOUNT($C$4:$Q$6,166,1,,$C$4:$Q$6=90,1)
J111	J111	=XCOUNT($C$4:$Q$6,166,,1,$C$4:$Q$6=90,1)
M109	M109	=XCOUNT($C$4:$Q$6,167,,,$C$4:$Q$6=90,1)
M110	M110	=XCOUNT($C$4:$Q$6,167,1,,$C$4:$Q$6=90,1)
M111	M111	=XCOUNT($C$4:$Q$6,167,,1,$C$4:$Q$6=90,1)
P109	P109	=XCOUNT($C$4:$Q$6,168,,,$C$4:$Q$6=90,1)
P110	P110	=XCOUNT($C$4:$Q$6,168,1,,$C$4:$Q$6=90,1)
P111	P111	=XCOUNT($C$4:$Q$6,168,,1,$C$4:$Q$6=90,1)
D115	D115	=XCOUNT($C$4:$Q$6,169,,,$C$4:$Q$6=90)
D116	D116	=XCOUNT($C$4:$Q$6,169,1,,$C$4:$Q$6=90)
D117	D117	=XCOUNT($C$4:$Q$6,169,,1,$C$4:$Q$6=90)
G115	G115	=XCOUNT($C$4:$Q$6,1610,,,$C$4:$Q$6=90)
G116	G116	=XCOUNT($C$4:$Q$6,1610,1,,$C$4:$Q$6=90)
G117	G117	=XCOUNT($C$4:$Q$6,1610,,1,$C$4:$Q$6=90)
J115	J115	=XCOUNT($C$4:$Q$6,1611,,,$C$4:$Q$6=90)
J116	J116	=XCOUNT($C$4:$Q$6,1611,1,,$C$4:$Q$6=90)
J117	J117	=XCOUNT($C$4:$Q$6,1611,,1,$C$4:$Q$6=90)
M115	M115	=XCOUNT($C$4:$Q$6,1612,,,$C$4:$Q$6=90)
M116	M116	=XCOUNT($C$4:$Q$6,1612,1,,$C$4:$Q$6=90)
M117	M117	=XCOUNT($C$4:$Q$6,1612,,1,$C$4:$Q$6=90)
P115	P115	=XCOUNT($C$4:$Q$6,1613,,,$C$4:$Q$6=90)
P116	P116	=XCOUNT($C$4:$Q$6,1613,1,,$C$4:$Q$6=90)
P117	P117	=XCOUNT($C$4:$Q$6,1613,,1,$C$4:$Q$6=90)
D119	D119	=XCOUNT($C$4:$Q$6,169,,,$C$4:$Q$6=90,1)
D120	D120	=XCOUNT($C$4:$Q$6,169,1,,$C$4:$Q$6=90,1)
D121	D121	=XCOUNT($C$4:$Q$6,169,,1,$C$4:$Q$6=90,1)
G119	G119	=XCOUNT($C$4:$Q$6,1610,,,$C$4:$Q$6=90,1)
G120	G120	=XCOUNT($C$4:$Q$6,1610,1,,$C$4:$Q$6=90,1)
G121	G121	=XCOUNT($C$4:$Q$6,1610,,1,$C$4:$Q$6=90,1)
J119	J119	=XCOUNT($C$4:$Q$6,1611,,,$C$4:$Q$6=90,1)
J120	J120	=XCOUNT($C$4:$Q$6,1611,1,,$C$4:$Q$6=90,1)
J121	J121	=XCOUNT($C$4:$Q$6,1611,,1,$C$4:$Q$6=90,1)
M119	M119	=XCOUNT($C$4:$Q$6,1612,,,$C$4:$Q$6=90,1)
M120	M120	=XCOUNT($C$4:$Q$6,1612,1,,$C$4:$Q$6=90,1)
M121	M121	=XCOUNT($C$4:$Q$6,1612,,1,$C$4:$Q$6=90,1)
P119	P119	=XCOUNT($C$4:$Q$6,1613,,,$C$4:$Q$6=90,1)
P120	P120	=XCOUNT($C$4:$Q$6,1613,1,,$C$4:$Q$6=90,1)
P121	P121	=XCOUNT($C$4:$Q$6,1613,,1,$C$4:$Q$6=90,1)
D125	D125	=XCOUNT($C$4:$Q$6,1614,,,$C$4:$Q$6=90)
D126	D126	=XCOUNT($C$4:$Q$6,1614,1,,$C$4:$Q$6=90)
D127	D127	=XCOUNT($C$4:$Q$6,1614,,1,$C$4:$Q$6=90)
D129	D129	=XCOUNT($C$4:$Q$6,1614,,,$C$4:$Q$6=90,1)
D130	D130	=XCOUNT($C$4:$Q$6,1614,1,,$C$4:$Q$6=90,1)
D131	D131	=XCOUNT($C$4:$Q$6,1614,,1,$C$4:$Q$6=90,1)

The following XL2BB provides examples with match criteria for texts:

xcount.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R
133
134		match criteria for texts
135
136			count type omitted			count type = 0			count type = 1			count type = 2			count type = 3
137			all			all			all			all			all
138			cells	#N/A		cells	#N/A		cells	0		cells	1		cells	0
139			rows	#N/A		rows	#N/A		rows	0		rows	1		rows	0
140			columns	#N/A		columns	#N/A		columns	0		columns	1		columns	0
141			excluding			excluding			excluding			excluding			excluding
142			cells	#N/A		cells	#N/A		cells	45		cells	44		cells	45
143			rows	#N/A		rows	#N/A		rows	3		rows	2		rows	3
144			columns	#N/A		columns	#N/A		columns	15		columns	14		columns	15
145
146			count type = 4			count type = 16			count type = 31			count type = 32			count type = 41
147			all			all			all			all			all
148			cells	0		cells	0		cells	0		cells	0		cells	0
149			rows	0		rows	0		rows	0		rows	0		rows	0
150			columns	0		columns	0		columns	0		columns	0		columns	0
151			excluding			excluding			excluding			excluding			excluding
152			cells	45		cells	45		cells	45		cells	45		cells	45
153			rows	3		rows	3		rows	3		rows	3		rows	3
154			columns	15		columns	15		columns	15		columns	15		columns	15
155
156			count type = 42			count type = 160			count type = 161			count type = 162			count type = 163
157			all			all			all			all			all
158			cells	0		cells	0		cells	0		cells	0		cells	0
159			rows	0		rows	0		rows	0		rows	0		rows	0
160			columns	0		columns	0		columns	0		columns	0		columns	0
161			excluding			excluding			excluding			excluding			excluding
162			cells	45		cells	45		cells	45		cells	45		cells	45
163			rows	3		rows	3		rows	3		rows	3		rows	3
164			columns	15		columns	15		columns	15		columns	15		columns	15
165
166			count type = 164			count type = 165			count type = 166			count type = 167			count type = 168
167			all			all			all			all			all
168			cells	0		cells	0		cells	0		cells	0		cells	0
169			rows	0		rows	0		rows	0		rows	0		rows	0
170			columns	0		columns	0		columns	0		columns	0		columns	0
171			excluding			excluding			excluding			excluding			excluding
172			cells	45		cells	45		cells	45		cells	45		cells	45
173			rows	3		rows	3		rows	3		rows	3		rows	3
174			columns	15		columns	15		columns	15		columns	15		columns	15
175
176			count type = 169			count type = 1610			count type = 1611			count type = 1612			count type = 1613
177			all			all			all			all			all
178			cells	0		cells	0		cells	0		cells	0		cells	0
179			rows	0		rows	0		rows	0		rows	0		rows	0
180			columns	0		columns	0		columns	0		columns	0		columns	0
181			excluding			excluding			excluding			excluding			excluding
182			cells	45		cells	45		cells	45		cells	45		cells	45
183			rows	3		rows	3		rows	3		rows	3		rows	3
184			columns	15		columns	15		columns	15		columns	15		columns	15
185
186			count type = 1614
187			all
188			cells	0
189			rows	0
190			columns	0
191			excluding
192			cells	45
193			rows	3
194			columns	15
195
196
Sheet3

Cell Formulas
Range	Formula
D138	D138	=XCOUNT($C$4:$Q$6,,,,$C$4:$Q$6="book")
D139	D139	=XCOUNT($C$4:$Q$6,,1,,$C$4:$Q$6="book")
D140	D140	=XCOUNT($C$4:$Q$6,,,1,$C$4:$Q$6="book")
G138	G138	=XCOUNT($C$4:$Q$6,0,,,$C$4:$Q$6="book")
G139	G139	=XCOUNT($C$4:$Q$6,0,1,,$C$4:$Q$6="book")
G140	G140	=XCOUNT($C$4:$Q$6,0,,1,$C$4:$Q$6="book")
J138	J138	=XCOUNT($C$4:$Q$6,1,,,$C$4:$Q$6="book")
J139	J139	=XCOUNT($C$4:$Q$6,1,1,,$C$4:$Q$6="book")
J140	J140	=XCOUNT($C$4:$Q$6,1,,1,$C$4:$Q$6="book")
M138	M138	=XCOUNT($C$4:$Q$6,2,,,$C$4:$Q$6="book")
M139	M139	=XCOUNT($C$4:$Q$6,2,1,,$C$4:$Q$6="book")
M140	M140	=XCOUNT($C$4:$Q$6,2,,1,$C$4:$Q$6="book")
P138	P138	=XCOUNT($C$4:$Q$6,3,,,$C$4:$Q$6="book")
P139	P139	=XCOUNT($C$4:$Q$6,3,1,,$C$4:$Q$6="book")
P140	P140	=XCOUNT($C$4:$Q$6,3,,1,$C$4:$Q$6="book")
D142	D142	=XCOUNT($C$4:$Q$6,,,,$C$4:$Q$6="book",1)
D143	D143	=XCOUNT($C$4:$Q$6,,1,,$C$4:$Q$6="book",1)
D144	D144	=XCOUNT($C$4:$Q$6,,,1,$C$4:$Q$6="book",1)
G142	G142	=XCOUNT($C$4:$Q$6,0,,,$C$4:$Q$6="book",1)
G143	G143	=XCOUNT($C$4:$Q$6,0,1,,$C$4:$Q$6="book",1)
G144	G144	=XCOUNT($C$4:$Q$6,0,,1,$C$4:$Q$6="book",1)
J142	J142	=XCOUNT($C$4:$Q$6,1,,,$C$4:$Q$6="book",1)
J143	J143	=XCOUNT($C$4:$Q$6,1,1,,$C$4:$Q$6="book",1)
J144	J144	=XCOUNT($C$4:$Q$6,1,,1,$C$4:$Q$6="book",1)
M142	M142	=XCOUNT($C$4:$Q$6,2,,,$C$4:$Q$6="book",1)
M143	M143	=XCOUNT($C$4:$Q$6,2,1,,$C$4:$Q$6="book",1)
M144	M144	=XCOUNT($C$4:$Q$6,2,,1,$C$4:$Q$6="book",1)
P142	P142	=XCOUNT($C$4:$Q$6,3,,,$C$4:$Q$6="book",1)
P143	P143	=XCOUNT($C$4:$Q$6,3,1,,$C$4:$Q$6="book",1)
P144	P144	=XCOUNT($C$4:$Q$6,3,,1,$C$4:$Q$6="book",1)
D148	D148	=XCOUNT($C$4:$Q$6,4,,,$C$4:$Q$6="book")
D149	D149	=XCOUNT($C$4:$Q$6,4,1,,$C$4:$Q$6="book")
D150	D150	=XCOUNT($C$4:$Q$6,4,,1,$C$4:$Q$6="book")
G148	G148	=XCOUNT($C$4:$Q$6,16,,,$C$4:$Q$6="book")
G149	G149	=XCOUNT($C$4:$Q$6,16,1,,$C$4:$Q$6="book")
G150	G150	=XCOUNT($C$4:$Q$6,16,,1,$C$4:$Q$6="book")
J148	J148	=XCOUNT($C$4:$Q$6,31,,,$C$4:$Q$6="book")
J149	J149	=XCOUNT($C$4:$Q$6,31,1,,$C$4:$Q$6="book")
J150	J150	=XCOUNT($C$4:$Q$6,31,,1,$C$4:$Q$6="book")
M148	M148	=XCOUNT($C$4:$Q$6,32,,,$C$4:$Q$6="book")
M149	M149	=XCOUNT($C$4:$Q$6,32,1,,$C$4:$Q$6="book")
M150	M150	=XCOUNT($C$4:$Q$6,32,,1,$C$4:$Q$6="book")
P148	P148	=XCOUNT($C$4:$Q$6,41,,,$C$4:$Q$6="book")
P149	P149	=XCOUNT($C$4:$Q$6,41,1,,$C$4:$Q$6="book")
P150	P150	=XCOUNT($C$4:$Q$6,41,,1,$C$4:$Q$6="book")
D152	D152	=XCOUNT($C$4:$Q$6,4,,,$C$4:$Q$6="book",1)
D153	D153	=XCOUNT($C$4:$Q$6,4,1,,$C$4:$Q$6="book",1)
D154	D154	=XCOUNT($C$4:$Q$6,4,,1,$C$4:$Q$6="book",1)
G152	G152	=XCOUNT($C$4:$Q$6,16,,,$C$4:$Q$6="book",1)
G153	G153	=XCOUNT($C$4:$Q$6,16,1,,$C$4:$Q$6="book",1)
G154	G154	=XCOUNT($C$4:$Q$6,16,,1,$C$4:$Q$6="book",1)
J152	J152	=XCOUNT($C$4:$Q$6,31,,,$C$4:$Q$6="book",1)
J153	J153	=XCOUNT($C$4:$Q$6,31,1,,$C$4:$Q$6="book",1)
J154	J154	=XCOUNT($C$4:$Q$6,31,,1,$C$4:$Q$6="book",1)
M152	M152	=XCOUNT($C$4:$Q$6,32,,,$C$4:$Q$6="book",1)
M153	M153	=XCOUNT($C$4:$Q$6,32,1,,$C$4:$Q$6="book",1)
M154	M154	=XCOUNT($C$4:$Q$6,32,,1,$C$4:$Q$6="book",1)
P152	P152	=XCOUNT($C$4:$Q$6,41,,,$C$4:$Q$6="book",1)
P153	P153	=XCOUNT($C$4:$Q$6,41,1,,$C$4:$Q$6="book",1)
P154	P154	=XCOUNT($C$4:$Q$6,41,,1,$C$4:$Q$6="book",1)
D158	D158	=XCOUNT($C$4:$Q$6,42,,,$C$4:$Q$6="book")
D159	D159	=XCOUNT($C$4:$Q$6,42,1,,$C$4:$Q$6="book")
D160	D160	=XCOUNT($C$4:$Q$6,42,,1,$C$4:$Q$6="book")
G158	G158	=XCOUNT($C$4:$Q$6,160,,,$C$4:$Q$6="book")
G159	G159	=XCOUNT($C$4:$Q$6,160,1,,$C$4:$Q$6="book")
G160	G160	=XCOUNT($C$4:$Q$6,160,,1,$C$4:$Q$6="book")
J158	J158	=XCOUNT($C$4:$Q$6,161,,,$C$4:$Q$6="book")
J159	J159	=XCOUNT($C$4:$Q$6,161,1,,$C$4:$Q$6="book")
J160	J160	=XCOUNT($C$4:$Q$6,161,,1,$C$4:$Q$6="book")
M158	M158	=XCOUNT($C$4:$Q$6,162,,,$C$4:$Q$6="book")
M159	M159	=XCOUNT($C$4:$Q$6,162,1,,$C$4:$Q$6="book")
M160	M160	=XCOUNT($C$4:$Q$6,162,,1,$C$4:$Q$6="book")
P158	P158	=XCOUNT($C$4:$Q$6,163,,,$C$4:$Q$6="book")
P159	P159	=XCOUNT($C$4:$Q$6,163,1,,$C$4:$Q$6="book")
P160	P160	=XCOUNT($C$4:$Q$6,163,,1,$C$4:$Q$6="book")
D162	D162	=XCOUNT($C$4:$Q$6,42,,,$C$4:$Q$6="book",1)
D163	D163	=XCOUNT($C$4:$Q$6,42,1,,$C$4:$Q$6="book",1)
D164	D164	=XCOUNT($C$4:$Q$6,42,,1,$C$4:$Q$6="book",1)
G162	G162	=XCOUNT($C$4:$Q$6,160,,,$C$4:$Q$6="book",1)
G163	G163	=XCOUNT($C$4:$Q$6,160,1,,$C$4:$Q$6="book",1)
G164	G164	=XCOUNT($C$4:$Q$6,160,,1,$C$4:$Q$6="book",1)
J162	J162	=XCOUNT($C$4:$Q$6,161,,,$C$4:$Q$6="book",1)
J163	J163	=XCOUNT($C$4:$Q$6,161,1,,$C$4:$Q$6="book",1)
J164	J164	=XCOUNT($C$4:$Q$6,161,,1,$C$4:$Q$6="book",1)
M162	M162	=XCOUNT($C$4:$Q$6,162,,,$C$4:$Q$6="book",1)
M163	M163	=XCOUNT($C$4:$Q$6,162,1,,$C$4:$Q$6="book",1)
M164	M164	=XCOUNT($C$4:$Q$6,162,,1,$C$4:$Q$6="book",1)
P162	P162	=XCOUNT($C$4:$Q$6,163,,,$C$4:$Q$6="book",1)
P163	P163	=XCOUNT($C$4:$Q$6,163,1,,$C$4:$Q$6="book",1)
P164	P164	=XCOUNT($C$4:$Q$6,163,,1,$C$4:$Q$6="book",1)
D168	D168	=XCOUNT($C$4:$Q$6,164,,,$C$4:$Q$6="book")
D169	D169	=XCOUNT($C$4:$Q$6,164,1,,$C$4:$Q$6="book")
D170	D170	=XCOUNT($C$4:$Q$6,164,,1,$C$4:$Q$6="book")
G168	G168	=XCOUNT($C$4:$Q$6,165,,,$C$4:$Q$6="book")
G169	G169	=XCOUNT($C$4:$Q$6,165,1,,$C$4:$Q$6="book")
G170	G170	=XCOUNT($C$4:$Q$6,165,,1,$C$4:$Q$6="book")
J168	J168	=XCOUNT($C$4:$Q$6,166,,,$C$4:$Q$6="book")
J169	J169	=XCOUNT($C$4:$Q$6,166,1,,$C$4:$Q$6="book")
J170	J170	=XCOUNT($C$4:$Q$6,166,,1,$C$4:$Q$6="book")
M168	M168	=XCOUNT($C$4:$Q$6,167,,,$C$4:$Q$6="book")
M169	M169	=XCOUNT($C$4:$Q$6,167,1,,$C$4:$Q$6="book")
M170	M170	=XCOUNT($C$4:$Q$6,167,,1,$C$4:$Q$6="book")
P168	P168	=XCOUNT($C$4:$Q$6,168,,,$C$4:$Q$6="book")
P169	P169	=XCOUNT($C$4:$Q$6,168,1,,$C$4:$Q$6="book")
P170	P170	=XCOUNT($C$4:$Q$6,168,,1,$C$4:$Q$6="book")
D172	D172	=XCOUNT($C$4:$Q$6,164,,,$C$4:$Q$6="book",1)
D173	D173	=XCOUNT($C$4:$Q$6,164,1,,$C$4:$Q$6="book",1)
D174	D174	=XCOUNT($C$4:$Q$6,164,,1,$C$4:$Q$6="book",1)
G172	G172	=XCOUNT($C$4:$Q$6,165,,,$C$4:$Q$6="book",1)
G173	G173	=XCOUNT($C$4:$Q$6,165,1,,$C$4:$Q$6="book",1)
G174	G174	=XCOUNT($C$4:$Q$6,165,,1,$C$4:$Q$6="book",1)
J172	J172	=XCOUNT($C$4:$Q$6,166,,,$C$4:$Q$6="book",1)
J173	J173	=XCOUNT($C$4:$Q$6,166,1,,$C$4:$Q$6="book",1)
J174	J174	=XCOUNT($C$4:$Q$6,166,,1,$C$4:$Q$6="book",1)
M172	M172	=XCOUNT($C$4:$Q$6,167,,,$C$4:$Q$6="book",1)
M173	M173	=XCOUNT($C$4:$Q$6,167,1,,$C$4:$Q$6="book",1)
M174	M174	=XCOUNT($C$4:$Q$6,167,,1,$C$4:$Q$6="book",1)
P172	P172	=XCOUNT($C$4:$Q$6,168,,,$C$4:$Q$6="book",1)
P173	P173	=XCOUNT($C$4:$Q$6,168,1,,$C$4:$Q$6="book",1)
P174	P174	=XCOUNT($C$4:$Q$6,168,,1,$C$4:$Q$6="book",1)
D178	D178	=XCOUNT($C$4:$Q$6,169,,,$C$4:$Q$6="book")
D179	D179	=XCOUNT($C$4:$Q$6,169,1,,$C$4:$Q$6="book")
D180	D180	=XCOUNT($C$4:$Q$6,169,,1,$C$4:$Q$6="book")
G178	G178	=XCOUNT($C$4:$Q$6,1610,,,$C$4:$Q$6="book")
G179	G179	=XCOUNT($C$4:$Q$6,1610,1,,$C$4:$Q$6="book")
G180	G180	=XCOUNT($C$4:$Q$6,1610,,1,$C$4:$Q$6="book")
J178	J178	=XCOUNT($C$4:$Q$6,1611,,,$C$4:$Q$6="book")
J179	J179	=XCOUNT($C$4:$Q$6,1611,1,,$C$4:$Q$6="book")
J180	J180	=XCOUNT($C$4:$Q$6,1611,,1,$C$4:$Q$6="book")
M178	M178	=XCOUNT($C$4:$Q$6,1612,,,$C$4:$Q$6="book")
M179	M179	=XCOUNT($C$4:$Q$6,1612,1,,$C$4:$Q$6="book")
M180	M180	=XCOUNT($C$4:$Q$6,1612,,1,$C$4:$Q$6="book")
P178	P178	=XCOUNT($C$4:$Q$6,1613,,,$C$4:$Q$6="book")
P179	P179	=XCOUNT($C$4:$Q$6,1613,1,,$C$4:$Q$6="book")
P180	P180	=XCOUNT($C$4:$Q$6,1613,,1,$C$4:$Q$6="book")
D182	D182	=XCOUNT($C$4:$Q$6,169,,,$C$4:$Q$6="book",1)
D183	D183	=XCOUNT($C$4:$Q$6,169,1,,$C$4:$Q$6="book",1)
D184	D184	=XCOUNT($C$4:$Q$6,169,,1,$C$4:$Q$6="book",1)
G182	G182	=XCOUNT($C$4:$Q$6,1610,,,$C$4:$Q$6="book",1)
G183	G183	=XCOUNT($C$4:$Q$6,1610,1,,$C$4:$Q$6="book",1)
G184	G184	=XCOUNT($C$4:$Q$6,1610,,1,$C$4:$Q$6="book",1)
J182	J182	=XCOUNT($C$4:$Q$6,1611,,,$C$4:$Q$6="book",1)
J183	J183	=XCOUNT($C$4:$Q$6,1611,1,,$C$4:$Q$6="book",1)
J184	J184	=XCOUNT($C$4:$Q$6,1611,,1,$C$4:$Q$6="book",1)
M182	M182	=XCOUNT($C$4:$Q$6,1612,,,$C$4:$Q$6="book",1)
M183	M183	=XCOUNT($C$4:$Q$6,1612,1,,$C$4:$Q$6="book",1)
M184	M184	=XCOUNT($C$4:$Q$6,1612,,1,$C$4:$Q$6="book",1)
P182	P182	=XCOUNT($C$4:$Q$6,1613,,,$C$4:$Q$6="book",1)
P183	P183	=XCOUNT($C$4:$Q$6,1613,1,,$C$4:$Q$6="book",1)
P184	P184	=XCOUNT($C$4:$Q$6,1613,,1,$C$4:$Q$6="book",1)
D188	D188	=XCOUNT($C$4:$Q$6,1614,,,$C$4:$Q$6="book")
D189	D189	=XCOUNT($C$4:$Q$6,1614,1,,$C$4:$Q$6="book")
D190	D190	=XCOUNT($C$4:$Q$6,1614,,1,$C$4:$Q$6="book")
D192	D192	=XCOUNT($C$4:$Q$6,1614,,,$C$4:$Q$6="book",1)
D193	D193	=XCOUNT($C$4:$Q$6,1614,1,,$C$4:$Q$6="book",1)
D194	D194	=XCOUNT($C$4:$Q$6,1614,,1,$C$4:$Q$6="book",1)

 

[Rnkhch]

Updated code:
1) addresses the issue where the function output is affected by incorrect parameters (i.e. function not crashing to a single #N/A)
2) enhanced the "type" parameter to "types" allowing for entering more than one data type (as many as you like). This allows for a remarkable level of flexibility and full resolution for counting the desired data types, as demonstrated through several examples in the attached XL2BB below. (Note that the number of type permutations are huge; I have only shown a few singles and doubles.)
3) the parameters that can be turned on/off, i.e. rows, columns, total_excluding, can now be controlled logically (instead of just 0/1) exactly like the native Excel parameters' style; this means that 0, omitted, or FALSE is off, and any number other than 0, or TRUE is on; this is accomplished through PLSL (see code below)
4) adopts modular coding allowing for conveniently reusing portions of code with specific functionalities (as I have done for all my other functions)

(You can download my template from the link in my signature below, which makes it easier to test the functions compared to pasting the XL2BB and entering the functions manually)

XCOUNT

=LAMBDA(reference,[types],[rows],[columns],[match_criteria],[total_excluding],
   LET(
      y,PLM(PO0(types),1),
      r,PLSL(rows),
      c,PLSL(columns),
      e,PLSL(total_excluding),
      m,IFERROR(match_criteria,0),
      d,IFS(AND(c=0,r=0),0,AND(c=0,r=1),1,AND(c=1,r=0),2),
      h,ISXTYPE(reference,FILTER(y,y>0),m,1),
      w,ROWS(reference)*COLUMNS(reference),
      i,IF(
         SUM(T1F0(MAP(y,LAMBDA(a,NOT(ISERROR(MATCH(a,{0},0))))))),
         SWITCH(d,
            0,w,
            1,ROWS(reference),
            2,COLUMNS(reference)),
         SWITCH(d,
            0,SUM(h),
            1,SUM(IF(BYROW(h,LAMBDA(a,SUM(a))),1,0)),
            2,SUM(IF(BYCOL(h,LAMBDA(a,SUM(a))),1,0)))
         ),
      SWITCH(d,
         0,LET(l,w,IF(e,l-i,i)),
         1,LET(m,ROWS(reference),IF(e,m-i,i)),
         2,LET(n,COLUMNS(reference),IF(e,n-i,i))
      )
   )
)

ISXTYPE (posted separately)

XERROR.TYPE (posted separately)

XTYPE (posted separately)

IO (shortened form of ISOMITTED)

JAB (Helper function: returns a number greater than or equal to 1 [i.e. TRUE] if the reference has the specified data type(s) and 0 [i.e. FALSE] otherwise)

=LAMBDA(types,advanced_types_array,
   LET(
      basic_types_array,SWITCH(advanced_types_array,1,1,2,2,31,3,32,3,41,4,42,4,16),
      MAP(advanced_types_array,LAMBDA(a,OR(a=types)))+MAP(basic_types_array,LAMBDA(a,OR(a=types)))
   )
)

JAN (Helper function: Returns TRUE if the reference is an array [i.e. is not a single element or is not omitted] and FALSE otherwise [simplified form of ISARRAY])

=LAMBDA([reference],LET(r,IFERROR(IF(reference="","",reference),""),IF(IO(reference),FALSE,IF(ROWS(r)*COLUMNS(r)>1,TRUE,FALSE))))

JAO (Helper function: Returns TRUE if the reference contains at least one error and FALSE otherwise [simplified form of ISERRORS])

=LAMBDA(reference,IF(IO(reference),FALSE,IF(SUM(IF(ISERROR(reference),1,0)),TRUE,FALSE)))

JAP (Helper function: Returns TRUE if the reference contains at least one blank and FALSE otherwise [simplified form of ISBLANKS])

=LAMBDA(reference,IF(IO(reference),NA(),IF(SUM(IF(IFERROR(reference,0)="",1,0)),TRUE,FALSE)))

OF (Returns "FALSE" if the reference is TRUE, "0" if the reference is FALSE, and #N/A otherwise)

=LAMBDA(reference,IF(ISERROR(IF(reference="",NA(),reference)),NA(),IFERROR(IF(reference,0,FALSE),NA())))

OT (Returns "TRUE" if the reference is TRUE, "1" if the reference is FALSE, and #N/A otherwise)

=LAMBDA(reference,IF(ISERROR(IF(reference="",NA(),reference)),NA(),IFERROR(IF(reference,1,TRUE),NA())))

PLM (stands for "parameter limit, multiple")
(Returns the entered parameter array (not blank or error) and #N/A otherwise)
(causes the function to crash to a single #N/A if the entered parameter array contains at least one error or blank)

=LAMBDA(parameter,[unique],
   IF(
      IF(OR(IO(parameter),JAO(parameter),JAP(parameter)),TRUE,IF(OR(ROWS(parameter)=1,COLUMNS(parameter)=1),FALSE,TRUE)),
      NA(),
      LET(
         u,PLSL(unique),
         IF(u,UNIQUE(parameter,1),parameter)
      )
   )
)

PLS (stands for "parameter limit, single")
(Returns the parameter if it is a single entry (not blank or error) and #N/A otherwise)
(Causes the function to crash to a single #N/A if the incorrect parameter is entered [either the wrong type or more than a single entry in array brackets "{}"])

=LAMBDA(parameter,INDEX(IF(OR(JAN(parameter),JAO(parameter),JAP(parameter)),NA(),parameter),1))

PLSL (stands for "parameter limit, single logical)
(Returns 1 if the parameter is a single TRUE entry; 0 if the parameter is a single FALSE entry or is omitted; and #N/A otherwise)
(Causes the function to crash to a single #N/A if incorrect parameters are entered [either anything not logically evaluateble or more than a single entry in array brackets "{}"]))

=LAMBDA([parameter],IF(IO(parameter),0,IF(JAN(parameter),NA(),LET(p,INDEX(parameter,1),IF(ISERROR(p),NA(),T1F0(p))))))

PO0 (Returns 0 if the parameter is omitted and the parameter itself otherwise)

=LAMBDA([parameter],IF(IO(parameter),0,parameter))

T1F0 (Returns 1 if the reference is TRUE, 0 if the reference is FALSE, and #N/A otherwise)

=LAMBDA(expression,IF(ISNUMBER(expression)+ISLOGICAL(expression),IF(expression,1,0),NA()))

Single types:

XCOUNT.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U
1
2			#CALC!																basic types
3																			1	dt:NUMBER
4			46	#N/A	94	76	book	70	82	TRUE	68		49	36		27	54		2	dt:TEXT
5			71	42	notebook	47	56	35	#DIV/0!	90	63	86	13	86	67	76	#CALC!		3	dt:BLANK
6			92	32	83	63	21	text	31	33	77	a	57	FALSE	16	41	64		4	dt:LOGICAL
7																			16	dt:ERROR
8		individual types
9																			advanced types
10			count type omitted			count type = 0			count type = 1			count type = 2			count type = 3				1	dt:NUMBER
11			all			all			all			all			all				2	dt:TEXT
12			cells	45	45	cells	45	45	cells	34	45	cells	4	45	cells	2	45		31	dt:BLANK_REAL
13			rows	3	3	rows	3	3	rows	3	3	rows	3	3	rows	1	3		32	dt:BLANK_FORMULA
14			columns	15	15	columns	15	15	columns	15	15	columns	4	15	columns	2	15		41	dt:LOGICAL_TRUE
15			excluding			excluding			excluding			excluding			excluding				42	dt:LOGICAL_FALSE
16			cells	0		cells	0		cells	11		cells	41		cells	43			160	dt:ERROR_EXTERNAL!
17			rows	0		rows	0		rows	0		rows	0		rows	2			161	dt:ERROR_NULL!
18			columns	0		columns	0		columns	0		columns	11		columns	13			162	dt:ERROR_DIV/0!
19																			163	dt:ERROR_VALUE!
20			count type = 4			count type = 16			count type = 31			count type = 32			count type = 41				164	dt:ERROR_REF!
21			all			all			all			all			all				165	dt:ERROR_NAME?
22			cells	2	45	cells	3	45	cells	1	45	cells	1	45	cells	1	45		166	dt:ERROR_NUM!
23			rows	2	3	rows	2	3	rows	1	3	rows	1	3	rows	1	3		167	dt:ERROR_N/A!
24			columns	2	15	columns	3	15	columns	1	15	columns	1	15	columns	1	15		168	dt:ERROR_GETTING_DATA!
25			excluding			excluding			excluding			excluding			excluding				169	dt:ERROR_SPILL!
26			cells	43		cells	42		cells	44		cells	44		cells	44			1610	dt:ERROR_CONNECT!
27			rows	1		rows	1		rows	2		rows	2		rows	2			1611	dt:ERROR_BLOCKED!
28			columns	13		columns	12		columns	14		columns	14		columns	14			1612	dt:ERROR_UNKNOWN!
29																			1613	dt:ERROR_FIELD!
30			count type = 42			count type = 160			count type = 161			count type = 162			count type = 163				1614	dt:ERROR_CALC!
31			all			all			all			all			all
32			cells	1	45	cells	0	45	cells	0	45	cells	1	45	cells	0	45
33			rows	1	3	rows	0	3	rows	0	3	rows	1	3	rows	0	3
34			columns	1	15	columns	0	15	columns	0	15	columns	1	15	columns	0	15
35			excluding			excluding			excluding			excluding			excluding
36			cells	44		cells	45		cells	45		cells	44		cells	45
37			rows	2		rows	3		rows	3		rows	2		rows	3
38			columns	14		columns	15		columns	15		columns	14		columns	15
39
40			count type = 164			count type = 165			count type = 166			count type = 167			count type = 168
41			all			all			all			all			all
42			cells	0	45	cells	0	45	cells	0	45	cells	1	45	cells	0	45
43			rows	0	3	rows	0	3	rows	0	3	rows	1	3	rows	0	3
44			columns	0	15	columns	0	15	columns	0	15	columns	1	15	columns	0	15
45			excluding			excluding			excluding			excluding			excluding
46			cells	45		cells	45		cells	45		cells	44		cells	45
47			rows	3		rows	3		rows	3		rows	2		rows	3
48			columns	15		columns	15		columns	15		columns	14		columns	15
49
50			count type = 169			count type = 1610			count type = 1611			count type = 1612			count type = 1613
51			all			all			all			all			all
52			cells	0	45	cells	0	45	cells	0	45	cells	0	45	cells	0	45
53			rows	0	3	rows	0	3	rows	0	3	rows	0	3	rows	0	3
54			columns	0	15	columns	0	15	columns	0	15	columns	0	15	columns	0	15
55			excluding			excluding			excluding			excluding			excluding
56			cells	45		cells	45		cells	45		cells	45		cells	45
57			rows	3		rows	3		rows	3		rows	3		rows	3
58			columns	15		columns	15		columns	15		columns	15		columns	15
59
60			count type = 1614
61			all
62			cells	1	45
63			rows	1	3
64			columns	1	15
65			excluding
66			cells	44
67			rows	2
68			columns	14
69
70
single

Cell Formulas
Range	Formula
C2	C2	=LAMBDA(reference,[types],[rows],[columns],[match_criteria],[total_excluding],LET(y,PLM(PO0(types),1),r,PLSL(rows),c,PLSL(columns),e,PLSL(total_excluding),m,IFERROR(match_criteria,0),d,IFS(AND(c=0,r=0),0,AND(c=0,r=1),1,AND(c=1,r=0),2),h,ISXTYPE(reference,FILTER(y,y>0),m,1),w,ROWS(reference)*COLUMNS(reference),i,IF(SUM(T1F0(MAP(y,LAMBDA(a,NOT(ISERROR(MATCH(a,{0},0))))))),SWITCH(d,0,w,1,ROWS(reference),2,COLUMNS(reference)),SWITCH(d,0,SUM(h),1,SUM(IF(BYROW(h,LAMBDA(a,SUM(a))),1,0)),2,SUM(IF(BYCOL(h,LAMBDA(a,SUM(a))),1,0)))),SWITCH(d,0,LET(l,w,IF(e,l-i,i)),1,LET(m,ROWS(reference),IF(e,m-i,i)),2,LET(n,COLUMNS(reference),IF(e,n-i,i)))))
D4	D4	=NA()
L4	L4	=IF(1,"")
I5	I5	=1/0
Q5	Q5	=LAMBDA("")
D12	D12	=XCOUNT($C$4:$Q$6)
E12:E14,E62:E64,Q52:Q54,N52:N54,K52:K54,H52:H54,E52:E54,Q42:Q44,N42:N44,K42:K44,H42:H44,E42:E44,Q32:Q34,N32:N34,K32:K34,H32:H34,E32:E34,Q22:Q24,N22:N24,K22:K24,H22:H24,E22:E24,Q12:Q14,N12:N14,K12:K14,H12:H14	E12	=D12+D16
D13	D13	=XCOUNT($C$4:$Q$6,,1)
D14,J14	D14	=XCOUNT($C$4:$Q$6,1,,1)
G12	G12	=XCOUNT($C$4:$Q$6,0)
G13	G13	=XCOUNT($C$4:$Q$6,0,1)
G14	G14	=XCOUNT($C$4:$Q$6,0,,1)
J12	J12	=XCOUNT($C$4:$Q$6,1)
J13	J13	=XCOUNT($C$4:$Q$6,1,1)
M12	M12	=XCOUNT($C$4:$Q$6,2)
M13	M13	=XCOUNT($C$4:$Q$6,2,1)
M14	M14	=XCOUNT($C$4:$Q$6,2,,1)
P12	P12	=XCOUNT($C$4:$Q$6,3)
P13	P13	=XCOUNT($C$4:$Q$6,3,1)
P14	P14	=XCOUNT($C$4:$Q$6,3,,1)
D16	D16	=XCOUNT($C$4:$Q$6,,,,,1)
D17	D17	=XCOUNT($C$4:$Q$6,,1,,,1)
D18	D18	=XCOUNT($C$4:$Q$6,,,1,,1)
G16	G16	=XCOUNT($C$4:$Q$6,0,,,,1)
G17	G17	=XCOUNT($C$4:$Q$6,0,1,,,1)
G18	G18	=XCOUNT($C$4:$Q$6,0,,1,,1)
J16	J16	=XCOUNT($C$4:$Q$6,1,,,,1)
J17	J17	=XCOUNT($C$4:$Q$6,1,1,,,1)
J18	J18	=XCOUNT($C$4:$Q$6,1,,1,,1)
M16	M16	=XCOUNT($C$4:$Q$6,2,,,,1)
M17	M17	=XCOUNT($C$4:$Q$6,2,1,,,1)
M18	M18	=XCOUNT($C$4:$Q$6,2,,1,,1)
P16	P16	=XCOUNT($C$4:$Q$6,3,,,,1)
P17	P17	=XCOUNT($C$4:$Q$6,3,1,,,1)
P18	P18	=XCOUNT($C$4:$Q$6,3,,1,,1)
D22	D22	=XCOUNT($C$4:$Q$6,4)
D23	D23	=XCOUNT($C$4:$Q$6,4,1)
D24	D24	=XCOUNT($C$4:$Q$6,4,,1)
G22	G22	=XCOUNT($C$4:$Q$6,16)
G23	G23	=XCOUNT($C$4:$Q$6,16,1)
G24	G24	=XCOUNT($C$4:$Q$6,16,,1)
J22	J22	=XCOUNT($C$4:$Q$6,31)
J23	J23	=XCOUNT($C$4:$Q$6,31,1)
J24	J24	=XCOUNT($C$4:$Q$6,31,,1)
M22	M22	=XCOUNT($C$4:$Q$6,32)
M23	M23	=XCOUNT($C$4:$Q$6,32,1)
M24	M24	=XCOUNT($C$4:$Q$6,32,,1)
P22	P22	=XCOUNT($C$4:$Q$6,41)
P23	P23	=XCOUNT($C$4:$Q$6,41,1)
P24	P24	=XCOUNT($C$4:$Q$6,41,,1)
D26	D26	=XCOUNT($C$4:$Q$6,4,,,,1)
D27	D27	=XCOUNT($C$4:$Q$6,4,1,,,1)
D28	D28	=XCOUNT($C$4:$Q$6,4,,1,,1)
G26	G26	=XCOUNT($C$4:$Q$6,16,,,,1)
G27	G27	=XCOUNT($C$4:$Q$6,16,1,,,1)
G28	G28	=XCOUNT($C$4:$Q$6,16,,1,,1)
J26	J26	=XCOUNT($C$4:$Q$6,31,,,,1)
J27	J27	=XCOUNT($C$4:$Q$6,31,1,,,1)
J28	J28	=XCOUNT($C$4:$Q$6,31,,1,,1)
M26	M26	=XCOUNT($C$4:$Q$6,32,,,,1)
M27	M27	=XCOUNT($C$4:$Q$6,32,1,,,1)
M28	M28	=XCOUNT($C$4:$Q$6,32,,1,,1)
P26	P26	=XCOUNT($C$4:$Q$6,41,,,,1)
P27	P27	=XCOUNT($C$4:$Q$6,41,1,,,1)
P28	P28	=XCOUNT($C$4:$Q$6,41,,1,,1)
D32	D32	=XCOUNT($C$4:$Q$6,42)
D33	D33	=XCOUNT($C$4:$Q$6,42,1)
D34	D34	=XCOUNT($C$4:$Q$6,42,,1)
G32	G32	=XCOUNT($C$4:$Q$6,160)
G33	G33	=XCOUNT($C$4:$Q$6,160,1)
G34	G34	=XCOUNT($C$4:$Q$6,160,,1)
J32	J32	=XCOUNT($C$4:$Q$6,161)
J33	J33	=XCOUNT($C$4:$Q$6,161,1)
J34	J34	=XCOUNT($C$4:$Q$6,161,,1)
M32	M32	=XCOUNT($C$4:$Q$6,162)
M33	M33	=XCOUNT($C$4:$Q$6,162,1)
M34	M34	=XCOUNT($C$4:$Q$6,162,,1)
P32	P32	=XCOUNT($C$4:$Q$6,163)
P33	P33	=XCOUNT($C$4:$Q$6,163,1)
P34	P34	=XCOUNT($C$4:$Q$6,163,,1)
D36	D36	=XCOUNT($C$4:$Q$6,42,,,,1)
D37	D37	=XCOUNT($C$4:$Q$6,42,1,,,1)
D38	D38	=XCOUNT($C$4:$Q$6,42,,1,,1)
G36	G36	=XCOUNT($C$4:$Q$6,160,,,,1)
G37	G37	=XCOUNT($C$4:$Q$6,160,1,,,1)
G38	G38	=XCOUNT($C$4:$Q$6,160,,1,,1)
J36	J36	=XCOUNT($C$4:$Q$6,161,,,,1)
J37	J37	=XCOUNT($C$4:$Q$6,161,1,,,1)
J38	J38	=XCOUNT($C$4:$Q$6,161,,1,,1)
M36	M36	=XCOUNT($C$4:$Q$6,162,,,,1)
M37	M37	=XCOUNT($C$4:$Q$6,162,1,,,1)
M38	M38	=XCOUNT($C$4:$Q$6,162,,1,,1)
P36	P36	=XCOUNT($C$4:$Q$6,163,,,,1)
P37	P37	=XCOUNT($C$4:$Q$6,163,1,,,1)
P38	P38	=XCOUNT($C$4:$Q$6,163,,1,,1)
D42	D42	=XCOUNT($C$4:$Q$6,164)
D43	D43	=XCOUNT($C$4:$Q$6,164,1)
D44	D44	=XCOUNT($C$4:$Q$6,164,,1)
G42	G42	=XCOUNT($C$4:$Q$6,165)
G43	G43	=XCOUNT($C$4:$Q$6,165,1)
G44	G44	=XCOUNT($C$4:$Q$6,165,,1)
J42	J42	=XCOUNT($C$4:$Q$6,166)
J43	J43	=XCOUNT($C$4:$Q$6,166,1)
J44	J44	=XCOUNT($C$4:$Q$6,166,,1)
M42	M42	=XCOUNT($C$4:$Q$6,167)
M43	M43	=XCOUNT($C$4:$Q$6,167,1)
M44	M44	=XCOUNT($C$4:$Q$6,167,,1)
P42	P42	=XCOUNT($C$4:$Q$6,168)
P43	P43	=XCOUNT($C$4:$Q$6,168,1)
P44	P44	=XCOUNT($C$4:$Q$6,168,,1)
D46	D46	=XCOUNT($C$4:$Q$6,164,,,,1)
D47	D47	=XCOUNT($C$4:$Q$6,164,1,,,1)
D48	D48	=XCOUNT($C$4:$Q$6,164,,1,,1)
G46	G46	=XCOUNT($C$4:$Q$6,165,,,,1)
G47	G47	=XCOUNT($C$4:$Q$6,165,1,,,1)
G48	G48	=XCOUNT($C$4:$Q$6,165,,1,,1)
J46	J46	=XCOUNT($C$4:$Q$6,166,,,,1)
J47	J47	=XCOUNT($C$4:$Q$6,166,1,,,1)
J48	J48	=XCOUNT($C$4:$Q$6,166,,1,,1)
M46	M46	=XCOUNT($C$4:$Q$6,167,,,,1)
M47	M47	=XCOUNT($C$4:$Q$6,167,1,,,1)
M48	M48	=XCOUNT($C$4:$Q$6,167,,1,,1)
P46	P46	=XCOUNT($C$4:$Q$6,168,,,,1)
P47	P47	=XCOUNT($C$4:$Q$6,168,1,,,1)
P48	P48	=XCOUNT($C$4:$Q$6,168,,1,,1)
D52	D52	=XCOUNT($C$4:$Q$6,169)
D53	D53	=XCOUNT($C$4:$Q$6,169,1)
D54	D54	=XCOUNT($C$4:$Q$6,169,,1)
G52	G52	=XCOUNT($C$4:$Q$6,1610)
G53	G53	=XCOUNT($C$4:$Q$6,1610,1)
G54	G54	=XCOUNT($C$4:$Q$6,1610,,1)
J52	J52	=XCOUNT($C$4:$Q$6,1611)
J53	J53	=XCOUNT($C$4:$Q$6,1611,1)
J54	J54	=XCOUNT($C$4:$Q$6,1611,,1)
M52	M52	=XCOUNT($C$4:$Q$6,1612)
M53	M53	=XCOUNT($C$4:$Q$6,1612,1)
M54	M54	=XCOUNT($C$4:$Q$6,1612,,1)
P52	P52	=XCOUNT($C$4:$Q$6,1613)
P53	P53	=XCOUNT($C$4:$Q$6,1613,1)
P54	P54	=XCOUNT($C$4:$Q$6,1613,,1)
D56	D56	=XCOUNT($C$4:$Q$6,169,,,,1)
D57	D57	=XCOUNT($C$4:$Q$6,169,1,,,1)
D58	D58	=XCOUNT($C$4:$Q$6,169,,1,,1)
G56	G56	=XCOUNT($C$4:$Q$6,1610,,,,1)
G57	G57	=XCOUNT($C$4:$Q$6,1610,1,,,1)
G58	G58	=XCOUNT($C$4:$Q$6,1610,,1,,1)
J56	J56	=XCOUNT($C$4:$Q$6,1611,,,,1)
J57	J57	=XCOUNT($C$4:$Q$6,1611,1,,,1)
J58	J58	=XCOUNT($C$4:$Q$6,1611,,1,,1)
M56	M56	=XCOUNT($C$4:$Q$6,1612,,,,1)
M57	M57	=XCOUNT($C$4:$Q$6,1612,1,,,1)
M58	M58	=XCOUNT($C$4:$Q$6,1612,,1,,1)
P56	P56	=XCOUNT($C$4:$Q$6,1613,,,,1)
P57	P57	=XCOUNT($C$4:$Q$6,1613,1,,,1)
P58	P58	=XCOUNT($C$4:$Q$6,1613,,1,,1)
D62	D62	=XCOUNT($C$4:$Q$6,1614)
D63	D63	=XCOUNT($C$4:$Q$6,1614,1)
D64	D64	=XCOUNT($C$4:$Q$6,1614,,1)
D66	D66	=XCOUNT($C$4:$Q$6,1614,,,,1)
D67	D67	=XCOUNT($C$4:$Q$6,1614,1,,,1)
D68	D68	=XCOUNT($C$4:$Q$6,1614,,1,,1)

 

[Rnkhch]

Multiple types:

XCOUNT.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U
1
2			#CALC!																basic types
3																			1	dt:NUMBER
4			46	#N/A	94	76	book	70	82	TRUE	68		49	36		27	54		2	dt:TEXT
5			71	42	notebook	47	56	35	#DIV/0!	90	63	86	13	86	67	76	#CALC!		3	dt:BLANK
6			92	32	83	63	21	text	31	33	77	a	57	FALSE	16	41	64		4	dt:LOGICAL
7																			16	dt:ERROR
8		multiple types
9																			advanced types
10			count type = {1,2}			count type = {1,3}			count type = {1,42}			count type = {1,16}			count type = {1,31}				1	dt:NUMBER
11			all			all			all			all			all				2	dt:TEXT
12			cells	38	45	cells	36	45	cells	35	45	cells	37	45	cells	35	45		31	dt:BLANK_REAL
13			rows	3	3	rows	3	3	rows	3	3	rows	3	3	rows	3	3		32	dt:BLANK_FORMULA
14			columns	15	15	columns	15	15	columns	15	15	columns	15	15	columns	15	15		41	dt:LOGICAL_TRUE
15			excluding			excluding			excluding			excluding			excluding				42	dt:LOGICAL_FALSE
16			cells	7		cells	9		cells	10		cells	8		cells	10			160	dt:ERROR_EXTERNAL!
17			rows	0		rows	0		rows	0		rows	0		rows	0			161	dt:ERROR_NULL!
18			columns	0		columns	0		columns	0		columns	0		columns	0			162	dt:ERROR_DIV/0!
19																			163	dt:ERROR_VALUE!
20			count type = {1,32}			count type = {1,41}			count type = {1,42}			count type = {1,162}			count type = {2,3}				164	dt:ERROR_REF!
21			all			all			all			all			all				165	dt:ERROR_NAME?
22			cells	35	45	cells	35	45	cells	35	45	cells	35	45	cells	6	45		166	dt:ERROR_NUM!
23			rows	3	3	rows	3	3	rows	3	3	rows	3	3	rows	3	3		167	dt:ERROR_N/A!
24			columns	15	15	columns	15	15	columns	15	15	columns	15	15	columns	5	15		168	dt:ERROR_GETTING_DATA!
25			excluding			excluding			excluding			excluding			excluding				169	dt:ERROR_SPILL!
26			cells	10		cells	10		cells	10		cells	10		cells	39			1610	dt:ERROR_CONNECT!
27			rows	0		rows	0		rows	0		rows	0		rows	0			1611	dt:ERROR_BLOCKED!
28			columns	0		columns	0		columns	0		columns	0		columns	10			1612	dt:ERROR_UNKNOWN!
29																			1613	dt:ERROR_FIELD!
30			count type = {2,4}			count type = {2,16}			count type = {2,31}			count type = {2,32}			count type = {2,41}				1614	dt:ERROR_CALC!
31			all			all			all			all			all
32			cells	6	45	cells	7	45	cells	5	45	cells	5	45	cells	5	45
33			rows	3	3	rows	3	3	rows	3	3	rows	3	3	rows	3	3
34			columns	6	15	columns	7	15	columns	5	15	columns	4	15	columns	5	15
35			excluding			excluding			excluding			excluding			excluding
36			cells	39		cells	38		cells	40		cells	40		cells	40
37			rows	0		rows	0		rows	0		rows	0		rows	0
38			columns	9		columns	8		columns	10		columns	11		columns	10
39
40			count type = {2,42}			count type = {2,167}			count type = {3,4}			count type = {3,31}			count type = {3,32}
41			all			all			all			all			all
42			cells	5	45	cells	5	45	cells	4	45	cells	2	45	cells	2	45
43			rows	3	3	rows	3	3	rows	2	3	rows	1	3	rows	1	3
44			columns	5	15	columns	5	15	columns	4	15	columns	2	15	columns	2	15
45			excluding			excluding			excluding			excluding			excluding
46			cells	40		cells	40		cells	41		cells	43		cells	43
47			rows	0		rows	0		rows	1		rows	2		rows	2
48			columns	10		columns	10		columns	11		columns	13		columns	13
49
50			count type = {3,41}			count type = {3,42}			count type = {3,167}			count type = {4,16}			count type = {4,31}
51			all			all			all			all			all
52			cells	3	45	cells	3	45	cells	3	45	cells	5	45	cells	3	45
53			rows	1	3	rows	2	3	rows	1	3	rows	3	3	rows	2	3
54			columns	3	15	columns	3	15	columns	3	15	columns	5	15	columns	3	15
55			excluding			excluding			excluding			excluding			excluding
56			cells	42		cells	42		cells	42		cells	40		cells	42
57			rows	2		rows	1		rows	2		rows	0		rows	1
58			columns	12		columns	12		columns	12		columns	10		columns	12
59
60			count type = {4,32}			count type = {4,41}			count type = {4,42}			count type = {4,1614}			count type = {16,31}
61			all			all			all			all			all
62			cells	3	45	cells	2	45	cells	2	45	cells	3	45	cells	4	45
63			rows	2	3	rows	2	3	rows	2	3	rows	3	3	rows	2	3
64			columns	3	15	columns	2	15	columns	2	15	columns	3	15	columns	4	15
65			excluding			excluding			excluding			excluding			excluding
66			cells	42		cells	43		cells	43		cells	42		cells	41
67			rows	1		rows	1		rows	1		rows	0		rows	1
68			columns	12		columns	13		columns	13		columns	12		columns	11
69
70			count type = {16,32}			count type = {16,41}			count type = {16,42}			count type = {16,162}			count type = {31,32}
71			all			all			all			all			all
72			cells	4	45	cells	4	45	cells	4	45	cells	3	45	cells	2	45
73			rows	2	3	rows	2	3	rows	3	3	rows	2	3	rows	1	3
74			columns	4	15	columns	4	15	columns	4	15	columns	3	15	columns	2	15
75			excluding			excluding			excluding			excluding			excluding
76			cells	41		cells	41		cells	41		cells	42		cells	43
77			rows	1		rows	1		rows	0		rows	1		rows	2
78			columns	11		columns	11		columns	11		columns	12		columns	13
79
80
multiple

Cell Formulas
Range	Formula
C2	C2	=LAMBDA(reference,[types],[rows],[columns],[match_criteria],[total_excluding],LET(y,PLM(PO0(types),1),r,PLSL(rows),c,PLSL(columns),e,PLSL(total_excluding),m,IFERROR(match_criteria,0),d,IFS(AND(c=0,r=0),0,AND(c=0,r=1),1,AND(c=1,r=0),2),h,ISXTYPE(reference,FILTER(y,y>0),m,1),w,ROWS(reference)*COLUMNS(reference),i,IF(SUM(T1F0(MAP(y,LAMBDA(a,NOT(ISERROR(MATCH(a,{0},0))))))),SWITCH(d,0,w,1,ROWS(reference),2,COLUMNS(reference)),SWITCH(d,0,SUM(h),1,SUM(IF(BYROW(h,LAMBDA(a,SUM(a))),1,0)),2,SUM(IF(BYCOL(h,LAMBDA(a,SUM(a))),1,0)))),SWITCH(d,0,LET(l,w,IF(e,l-i,i)),1,LET(m,ROWS(reference),IF(e,m-i,i)),2,LET(n,COLUMNS(reference),IF(e,n-i,i)))))
D4	D4	=NA()
L4	L4	=IF(1,"")
I5	I5	=1/0
Q5	Q5	=LAMBDA("")
D12	D12	=XCOUNT($C$4:$Q$6,{1,2})
E12:E14,Q72:Q74,N72:N74,K72:K74,H72:H74,E72:E74,Q62:Q64,N62:N64,K62:K64,H62:H64,E62:E64,Q52:Q54,N52:N54,K52:K54,H52:H54,E52:E54,Q42:Q44,N42:N44,K42:K44,H42:H44,E42:E44,Q32:Q34,N32:N34,K32:K34,H32:H34,E32:E34,Q22:Q24,N22:N24,K22:K24,H22:H24,E22:E24,Q12:Q14	E12	=D12+D16
D13	D13	=XCOUNT($C$4:$Q$6,{1,2},1)
D14	D14	=XCOUNT($C$4:$Q$6,{1,2},,1)
G12	G12	=XCOUNT($C$4:$Q$6,{1,3})
G13	G13	=XCOUNT($C$4:$Q$6,{1,3},1)
G14	G14	=XCOUNT($C$4:$Q$6,{1,3},,1)
J12,J22	J12	=XCOUNT($C$4:$Q$6,{1,42})
J13,J23	J13	=XCOUNT($C$4:$Q$6,{1,42},1)
J14,J24	J14	=XCOUNT($C$4:$Q$6,{1,42},,1)
M12	M12	=XCOUNT($C$4:$Q$6,{1,16})
M13	M13	=XCOUNT($C$4:$Q$6,{1,16},1)
M14	M14	=XCOUNT($C$4:$Q$6,{1,16},,1)
P12	P12	=XCOUNT($C$4:$Q$6,{1,31})
P13	P13	=XCOUNT($C$4:$Q$6,{1,31},1)
P14	P14	=XCOUNT($C$4:$Q$6,{1,31},,1)
D16	D16	=XCOUNT($C$4:$Q$6,{1,2},,,,1)
D17	D17	=XCOUNT($C$4:$Q$6,{1,2},1,,,1)
D18	D18	=XCOUNT($C$4:$Q$6,{1,2},,1,,1)
G16	G16	=XCOUNT($C$4:$Q$6,{1,3},,,,1)
G17	G17	=XCOUNT($C$4:$Q$6,{1,3},1,,,1)
G18	G18	=XCOUNT($C$4:$Q$6,{1,3},,1,,1)
J16,J26	J16	=XCOUNT($C$4:$Q$6,{1,42},,,,1)
J17,J27	J17	=XCOUNT($C$4:$Q$6,{1,42},1,,,1)
J18,J28	J18	=XCOUNT($C$4:$Q$6,{1,42},,1,,1)
M16	M16	=XCOUNT($C$4:$Q$6,{1,16},,,,1)
M17	M17	=XCOUNT($C$4:$Q$6,{1,16},1,,,1)
M18	M18	=XCOUNT($C$4:$Q$6,{1,16},,1,,1)
P16	P16	=XCOUNT($C$4:$Q$6,{1,31},,,,1)
P17	P17	=XCOUNT($C$4:$Q$6,{1,31},1,,,1)
P18	P18	=XCOUNT($C$4:$Q$6,{1,31},,1,,1)
D22	D22	=XCOUNT($C$4:$Q$6,{1,32})
D23	D23	=XCOUNT($C$4:$Q$6,{1,32},1)
D24	D24	=XCOUNT($C$4:$Q$6,{1,32},,1)
G22	G22	=XCOUNT($C$4:$Q$6,{1,41})
G23	G23	=XCOUNT($C$4:$Q$6,{1,41},1)
G24	G24	=XCOUNT($C$4:$Q$6,{1,41},,1)
M22	M22	=XCOUNT($C$4:$Q$6,{1,162})
M23	M23	=XCOUNT($C$4:$Q$6,{1,162},1)
M24	M24	=XCOUNT($C$4:$Q$6,{1,162},,1)
P22	P22	=XCOUNT($C$4:$Q$6,{2,3})
P23	P23	=XCOUNT($C$4:$Q$6,{2,3},1)
P24	P24	=XCOUNT($C$4:$Q$6,{2,3},,1)
D26	D26	=XCOUNT($C$4:$Q$6,{1,32},,,,1)
D27	D27	=XCOUNT($C$4:$Q$6,{1,32},1,,,1)
D28	D28	=XCOUNT($C$4:$Q$6,{1,32},,1,,1)
G26	G26	=XCOUNT($C$4:$Q$6,{1,41},,,,1)
G27	G27	=XCOUNT($C$4:$Q$6,{1,41},1,,,1)
G28	G28	=XCOUNT($C$4:$Q$6,{1,41},,1,,1)
M26	M26	=XCOUNT($C$4:$Q$6,{1,162},,,,1)
M27	M27	=XCOUNT($C$4:$Q$6,{1,162},1,,,1)
M28	M28	=XCOUNT($C$4:$Q$6,{1,162},,1,,1)
P26	P26	=XCOUNT($C$4:$Q$6,{2,3},,,,1)
P27	P27	=XCOUNT($C$4:$Q$6,{2,3},1,,,1)
P28	P28	=XCOUNT($C$4:$Q$6,{2,3},,1,,1)
D32	D32	=XCOUNT($C$4:$Q$6,{2,4})
D33	D33	=XCOUNT($C$4:$Q$6,{2,4},1)
D34	D34	=XCOUNT($C$4:$Q$6,{2,4},,1)
G32	G32	=XCOUNT($C$4:$Q$6,{2,16})
G33	G33	=XCOUNT($C$4:$Q$6,{2,16},1)
G34	G34	=XCOUNT($C$4:$Q$6,{2,16},,1)
J32	J32	=XCOUNT($C$4:$Q$6,{2,31})
J33	J33	=XCOUNT($C$4:$Q$6,{2,31},1)
J34	J34	=XCOUNT($C$4:$Q$6,{2,31},,1)
M32	M32	=XCOUNT($C$4:$Q$6,{2,32})
M33	M33	=XCOUNT($C$4:$Q$6,{2,32},1)
M34	M34	=XCOUNT($C$4:$Q$6,{2,32},,1)
P32	P32	=XCOUNT($C$4:$Q$6,{2,41})
P33	P33	=XCOUNT($C$4:$Q$6,{2,41},1)
P34	P34	=XCOUNT($C$4:$Q$6,{2,41},,1)
D36	D36	=XCOUNT($C$4:$Q$6,{2,4},,,,1)
D37	D37	=XCOUNT($C$4:$Q$6,{2,4},1,,,1)
D38	D38	=XCOUNT($C$4:$Q$6,{2,4},,1,,1)
G36	G36	=XCOUNT($C$4:$Q$6,{2,16},,,,1)
G37	G37	=XCOUNT($C$4:$Q$6,{2,16},1,,,1)
G38	G38	=XCOUNT($C$4:$Q$6,{2,16},,1,,1)
J36	J36	=XCOUNT($C$4:$Q$6,{2,31},,,,1)
J37	J37	=XCOUNT($C$4:$Q$6,{2,31},1,,,1)
J38	J38	=XCOUNT($C$4:$Q$6,{2,31},,1,,1)
M36	M36	=XCOUNT($C$4:$Q$6,{2,32},,,,1)
M37	M37	=XCOUNT($C$4:$Q$6,{2,32},1,,,1)
M38	M38	=XCOUNT($C$4:$Q$6,{2,32},,1,,1)
P36	P36	=XCOUNT($C$4:$Q$6,{2,41},,,,1)
P37	P37	=XCOUNT($C$4:$Q$6,{2,41},1,,,1)
P38	P38	=XCOUNT($C$4:$Q$6,{2,41},,1,,1)
D42	D42	=XCOUNT($C$4:$Q$6,{2,42})
D43	D43	=XCOUNT($C$4:$Q$6,{2,42},1)
D44	D44	=XCOUNT($C$4:$Q$6,{2,42},,1)
G42	G42	=XCOUNT($C$4:$Q$6,{2,167})
G43	G43	=XCOUNT($C$4:$Q$6,{2,167},1)
G44	G44	=XCOUNT($C$4:$Q$6,{2,167},,1)
J42	J42	=XCOUNT($C$4:$Q$6,{3,4})
J43	J43	=XCOUNT($C$4:$Q$6,{3,4},1)
J44	J44	=XCOUNT($C$4:$Q$6,{3,4},,1)
M42	M42	=XCOUNT($C$4:$Q$6,{3,31})
M43	M43	=XCOUNT($C$4:$Q$6,{3,31},1)
M44	M44	=XCOUNT($C$4:$Q$6,{3,31},,1)
P42	P42	=XCOUNT($C$4:$Q$6,{3,32})
P43	P43	=XCOUNT($C$4:$Q$6,{3,32},1)
P44	P44	=XCOUNT($C$4:$Q$6,{3,32},,1)
D46	D46	=XCOUNT($C$4:$Q$6,{2,42},,,,1)
D47	D47	=XCOUNT($C$4:$Q$6,{2,42},1,,,1)
D48	D48	=XCOUNT($C$4:$Q$6,{2,42},,1,,1)
G46	G46	=XCOUNT($C$4:$Q$6,{2,167},,,,1)
G47	G47	=XCOUNT($C$4:$Q$6,{2,167},1,,,1)
G48	G48	=XCOUNT($C$4:$Q$6,{2,167},,1,,1)
J46	J46	=XCOUNT($C$4:$Q$6,{3,4},,,,1)
J47	J47	=XCOUNT($C$4:$Q$6,{3,4},1,,,1)
J48	J48	=XCOUNT($C$4:$Q$6,{3,4},,1,,1)
M46	M46	=XCOUNT($C$4:$Q$6,{3,31},,,,1)
M47	M47	=XCOUNT($C$4:$Q$6,{3,31},1,,,1)
M48	M48	=XCOUNT($C$4:$Q$6,{3,31},,1,,1)
P46	P46	=XCOUNT($C$4:$Q$6,{3,32},,,,1)
P47	P47	=XCOUNT($C$4:$Q$6,{3,32},1,,,1)
P48	P48	=XCOUNT($C$4:$Q$6,{3,32},,1,,1)
D52	D52	=XCOUNT($C$4:$Q$6,{3,41})
D53	D53	=XCOUNT($C$4:$Q$6,{3,41},1)
D54	D54	=XCOUNT($C$4:$Q$6,{3,41},,1)
G52	G52	=XCOUNT($C$4:$Q$6,{3,42})
G53	G53	=XCOUNT($C$4:$Q$6,{3,42},1)
G54	G54	=XCOUNT($C$4:$Q$6,{3,42},,1)
J52	J52	=XCOUNT($C$4:$Q$6,{3,167})
J53	J53	=XCOUNT($C$4:$Q$6,{3,167},1)
J54	J54	=XCOUNT($C$4:$Q$6,{3,167},,1)
M52	M52	=XCOUNT($C$4:$Q$6,{4,16})
M53	M53	=XCOUNT($C$4:$Q$6,{4,16},1)
M54	M54	=XCOUNT($C$4:$Q$6,{4,16},,1)
P52	P52	=XCOUNT($C$4:$Q$6,{4,31})
P53	P53	=XCOUNT($C$4:$Q$6,{4,31},1)
P54	P54	=XCOUNT($C$4:$Q$6,{4,31},,1)
D56	D56	=XCOUNT($C$4:$Q$6,{3,41},,,,1)
D57	D57	=XCOUNT($C$4:$Q$6,{3,41},1,,,1)
D58	D58	=XCOUNT($C$4:$Q$6,{3,41},,1,,1)
G56	G56	=XCOUNT($C$4:$Q$6,{3,42},,,,1)
G57	G57	=XCOUNT($C$4:$Q$6,{3,42},1,,,1)
G58	G58	=XCOUNT($C$4:$Q$6,{3,42},,1,,1)
J56	J56	=XCOUNT($C$4:$Q$6,{3,167},,,,1)
J57	J57	=XCOUNT($C$4:$Q$6,{3,167},1,,,1)
J58	J58	=XCOUNT($C$4:$Q$6,{3,167},,1,,1)
M56	M56	=XCOUNT($C$4:$Q$6,{4,16},,,,1)
M57	M57	=XCOUNT($C$4:$Q$6,{4,16},1,,,1)
M58	M58	=XCOUNT($C$4:$Q$6,{4,16},,1,,1)
P56	P56	=XCOUNT($C$4:$Q$6,{4,31},,,,1)
P57	P57	=XCOUNT($C$4:$Q$6,{4,31},1,,,1)
P58	P58	=XCOUNT($C$4:$Q$6,{4,31},,1,,1)
D62	D62	=XCOUNT($C$4:$Q$6,{4,32})
D63	D63	=XCOUNT($C$4:$Q$6,{4,32},1)
D64	D64	=XCOUNT($C$4:$Q$6,{4,32},,1)
G62	G62	=XCOUNT($C$4:$Q$6,{4,41})
G63	G63	=XCOUNT($C$4:$Q$6,{4,41},1)
G64	G64	=XCOUNT($C$4:$Q$6,{4,41},,1)
J62	J62	=XCOUNT($C$4:$Q$6,{4,42})
J63	J63	=XCOUNT($C$4:$Q$6,{4,42},1)
J64	J64	=XCOUNT($C$4:$Q$6,{4,42},,1)
M62	M62	=XCOUNT($C$4:$Q$6,{4,1614})
M63	M63	=XCOUNT($C$4:$Q$6,{4,1614},1)
M64	M64	=XCOUNT($C$4:$Q$6,{4,1614},,1)
P62	P62	=XCOUNT($C$4:$Q$6,{16,31})
P63	P63	=XCOUNT($C$4:$Q$6,{16,31},1)
P64	P64	=XCOUNT($C$4:$Q$6,{16,31},,1)
D66	D66	=XCOUNT($C$4:$Q$6,{4,32},,,,1)
D67	D67	=XCOUNT($C$4:$Q$6,{4,32},1,,,1)
D68	D68	=XCOUNT($C$4:$Q$6,{4,32},,1,,1)
G66	G66	=XCOUNT($C$4:$Q$6,{4,41},,,,1)
G67	G67	=XCOUNT($C$4:$Q$6,{4,41},1,,,1)
G68	G68	=XCOUNT($C$4:$Q$6,{4,41},,1,,1)
J66	J66	=XCOUNT($C$4:$Q$6,{4,42},,,,1)
J67	J67	=XCOUNT($C$4:$Q$6,{4,42},1,,,1)
J68	J68	=XCOUNT($C$4:$Q$6,{4,42},,1,,1)
M66	M66	=XCOUNT($C$4:$Q$6,{4,1614},,,,1)
M67	M67	=XCOUNT($C$4:$Q$6,{4,1614},1,,,1)
M68	M68	=XCOUNT($C$4:$Q$6,{4,1614},,1,,1)
P66	P66	=XCOUNT($C$4:$Q$6,{16,31},,,,1)
P67	P67	=XCOUNT($C$4:$Q$6,{16,31},1,,,1)
P68	P68	=XCOUNT($C$4:$Q$6,{16,31},,1,,1)
D72	D72	=XCOUNT($C$4:$Q$6,{16,32})
D73	D73	=XCOUNT($C$4:$Q$6,{16,32},1)
D74	D74	=XCOUNT($C$4:$Q$6,{16,32},,1)
G72	G72	=XCOUNT($C$4:$Q$6,{16,41})
G73	G73	=XCOUNT($C$4:$Q$6,{16,41},1)
G74	G74	=XCOUNT($C$4:$Q$6,{16,41},,1)
J72	J72	=XCOUNT($C$4:$Q$6,{16,42})
J73	J73	=XCOUNT($C$4:$Q$6,{16,42},1)
J74	J74	=XCOUNT($C$4:$Q$6,{16,42},,1)
M72	M72	=XCOUNT($C$4:$Q$6,{16,162})
M73	M73	=XCOUNT($C$4:$Q$6,{16,162},1)
M74	M74	=XCOUNT($C$4:$Q$6,{16,162},,1)
P72	P72	=XCOUNT($C$4:$Q$6,{31,32})
P73	P73	=XCOUNT($C$4:$Q$6,{31,32},1)
P74	P74	=XCOUNT($C$4:$Q$6,{31,32},,1)
D76	D76	=XCOUNT($C$4:$Q$6,{16,32},,,,1)
D77	D77	=XCOUNT($C$4:$Q$6,{16,32},1,,,1)
D78	D78	=XCOUNT($C$4:$Q$6,{16,32},,1,,1)
G76	G76	=XCOUNT($C$4:$Q$6,{16,41},,,,1)
G77	G77	=XCOUNT($C$4:$Q$6,{16,41},1,,,1)
G78	G78	=XCOUNT($C$4:$Q$6,{16,41},,1,,1)
J76	J76	=XCOUNT($C$4:$Q$6,{16,42},,,,1)
J77	J77	=XCOUNT($C$4:$Q$6,{16,42},1,,,1)
J78	J78	=XCOUNT($C$4:$Q$6,{16,42},,1,,1)
M76	M76	=XCOUNT($C$4:$Q$6,{16,162},,,,1)
M77	M77	=XCOUNT($C$4:$Q$6,{16,162},1,,,1)
M78	M78	=XCOUNT($C$4:$Q$6,{16,162},,1,,1)
P76	P76	=XCOUNT($C$4:$Q$6,{31,32},,,,1)
P77	P77	=XCOUNT($C$4:$Q$6,{31,32},1,,,1)
P78	P78	=XCOUNT($C$4:$Q$6,{31,32},,1,,1)