Countif formula???

[motherteresa]

Need help fellow Excellers...

Column G has either "A" or "B" placed in each row.

Column L has either "X" or "Y" placed in each row.

(The values above are internal coding. They could be any value, really)

Trying to calculate the percentage of "X's" that appear in column L that are assigned to "A" versus "B" in column G

So, given that column G contains 20 "A's" and the corresponding value in column L shows 15 "X's" and 5 "Y's", the result would be 75%

Thanks in advance for any help.

 

[Legacy 436357]

I tried this way maybe it will help:

Excel Workbook
	G	L	M	N
2	A	X	A's	16
3	B	Y	B's	15
4	B	Y	X's	18
5	B	X	Y's	13
6	B	Y	Total Rows	31
7	B	X	Count Matches	11
8	B	Y	% of Matches	35%
9	B	X
10	A	X
11	A	X
12	A	X
13	A	X
14	A	X
15	A	Y
16	A	Y
17	A	Y
18	B	Y
19	A	Y
20	A	Y
21	A	X
22	A	X
23	A	X
24	A	X
25	A	X
26	B	X
27	B	X
28	B	X
29	B	X
30	B	Y
31	B	Y
32	B	Y
Sheet1

 

[Fluff]

How about
=COUNTIFS(G:G,"A",H:H,"X")/COUNTIF(G:G,"A")

 

[Legacy 436357]

Sorry but it results in "0"

 

[Legacy 436357]

Fluff had it correct except for reference to column H it should be column L

 

[Fluff]

Missed it was cols G & L, not G & H.
In which case

Excel 2013/2016
	G	L	M
2	A	X	0.75
3	A	Y
4	B	Y
5	B	X
6	B	Y
7	A	X
8	B	Y
9	A	X
10	A	X
11	A	X
12	A	X
13	A	X
14	A	X
15	A	Y
16	A	Y
17	A	Y
18	B	Y
19	A	Y
20	A	X
21	A	X
22	A	X
23	A	X
24	A	X
25	A	X
26	A	X
27	B	X
Sheet2

Cell Formulas
Range	Formula
M2	=COUNTIFS(G:G,"A",L:L,"X")/COUNTIF(G:G,"A")