Need Count Formula

[CARBOB]

https://app.box.com/s/3ak713qk5hg9xdklyzl4plimyp4xjthf



Need a formula in columns L25:BW25 to count the number of hits for each 3 values in L1:BW1. The existing formula does not recognize double or triple numbers.

 

[CARBOB]

LINK https://app.box.com/s/opa35wlcfzhx0clnulpw6x3vc0dfb92a
New link

 

[CARBOB]

https://app.box.com/s/opa35wlcfzhx0clnulpw6x3vc0dfb92a

 

[Fluff]

Not sure if I've understood correctly, but how about in L25
=SUM(ISNUMBER(FIND($G25,L$1)),ISNUMBER(FIND($H25,L$1)),ISNUMBER(FIND($I25,L$1)))

 

[CARBOB]

Not sure if I've understood correctly, but how about in L25
=SUM(ISNUMBER(FIND($G25,L$1)),ISNUMBER(FIND($H25,L$1)),ISNUMBER(FIND($I25,L$1)))

https://app.box.com/s/opa35wlcfzhx0clnulpw6x3vc0dfb92a

In columns O,P,Q formula not returning right count, returns 3 when only 2 match. Use the values in row 1 to match values in G:I.

 

[Fluff]

You have a typo in your formula, the last part of each FIND function should be L$1

 

[jtakw]

Hi,

For your uploaded Sample, try this entered in L7, copied down and across to BD13.
Does this give you the results you require?

Book1
	G	H	I	J	K	L	M	N	O	P	Q
1				TRUE	1	0,1,3	0,3,1	1,0,3	1,3,0	3,0,1	3,1,0
2
3
4
5
6
7	0	3	3	6	6	2	2	2	2	2	2
8	0	1	3	4	4	3	3	3	3	3	3
9	0	1	2	3	3	2	2	2	2	2	2
10	0	3	3	6	6	2	2	2	2	2	2
11	1	2	3	6	6	2	2	2	2	2	2
12	0	1	1	2	2	2	2	2	2	2	2
13	0	1	2	3	3	2	2	2	2	2	2
4-DIGIT

Cell Formulas
Range	Formula
L7	=LEN(L$1)-LEN(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(L$1,$G7,""),$H7,""),$I7,""))

 

[CARBOB]

https://app.box.com/s/opa35wlcfzhx0clnulpw6x3vc0dfb92a

The value in AR7 should be 2 , value in AS is correct.

 

[jtakw]

Try this modified version, see if it gives you your required results, I don't have time to go thru all the data but have checked L7:AS7 and results seems correct.

Book1
	G	H	I	J	K	L	M	N	O	P	Q
1				TRUE	1	0,1,3	0,3,1	1,0,3	1,3,0	3,0,1	3,1,0
2
3
4
5
6
7	0	3	3	6	6	2	2	2	2	2	2
8	0	1	3	4	4	3	3	3	3	3	3
9	0	1	2	3	3	2	2	2	2	2	2
10	0	3	3	6	6	2	2	2	2	2	2
11	1	2	3	6	6	2	2	2	2	2	2
12	0	1	1	2	2	2	2	2	2	2	2
13	0	1	2	3	3	2	2	2	2	2	2
4-DIGIT

Cell Formulas
Range	Formula
L7	=LEN(L$1)-LEN(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(L$1,$G7,"",1),$H7,"",1),$I7,"",1))