quora_match_cells_words.xlsx

	A	B	D	E	F	G	H	I	J	K	L	M
1	How can I find the total number of matching cells in two Excel columns which specifically contain a text value that I require?
2	Duncan Williamson
3
4	Fruit	Colour	Fruit	Banana			Green	Yellow	Red	Orange	Golden	Purple
5	Apple	Green	Colour	Yellow		Apple	4		7		4
6	Banana	Yellow	Number	10	=COUNTIFS(A5:A54,E4,B5:B54,E5)	Banana		10
7	Strawberries	Red				Strawberries			4
8	Apple	Green	Fruit List			Orange				5
9	Orange	Orange	Apple	15	=COUNTIF(A$5:A$54,D9)	Pear	7	4
10	Banana	Yellow	Banana	10		Grapes						5
11	Apple	Red	Strawberries	4
12	Banana	Yellow	Orange	5			=IF(COUNTIFS( $A$5:$A$54,$G5,$B$5:$B$54,H$4)=0,"", COUNTIFS( $A$5:$A$54,$G5,$B$5:$B$54,H$4))
13	Apple	Green	Pear	11
14	Pear	Green	Grapes	5
15	Apple	Red	Total	50	=COUNTA(A5:A54)
16	Apple	Golden
17	Grapes	Purple	Colour List
18	Orange	Orange	Green	11	=COUNTIF(B$5:B$54,D18)
19	Grapes	Purple	Yellow	14
20	Apple	Red	Red	11
21	Grapes	Purple	Orange	5
22	Banana	Yellow	Golden	4
23	Orange	Orange	Purple	5
24	Banana	Yellow	Total	50	=COUNTA(B5:B54)
25	Apple	Green
26	Pear	Green
27	Banana	Yellow
28	Apple	Red
29	Pear	Yellow
30	Strawberries	Red
31	Pear	Yellow
32	Apple	Red
33	Apple	Red
34	Banana	Yellow
35	Apple	Golden
36	Pear	Green
37	Pear	Green
38	Grapes	Purple
39	Grapes	Purple
40	Banana	Yellow
41	Orange	Orange
42	Apple	Red
43	Pear	Yellow
44	Strawberries	Red
45	Apple	Golden
46	Pear	Green
47	Pear	Green
48	Pear	Green
49	Pear	Yellow
50	Apple	Golden
51	Banana	Yellow
52	Orange	Orange
53	Banana	Yellow
54	Strawberries	Red
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100