populated cells average

[domdc1]

Hi there all
Although ive read similar replies i cant seem to locate something specific to my question. I have a variety of cells within a1:a10, within these cells the reply is either 'Y', 'N' or 'NA'. I need to calculate the percentage of Yes compared to the total. For example if 5 cells have 'Y' and the rest have 'N' its 50% (5/10), but if 2 cells have 'NA' the total would be (5/8) as the NA cells are not calculated.

Thanks in advance
p.s. i have another issue with a scheduling problem, but ill ask that later, ill search the threads first.

 

[Smitty]

You can use COUNTIF:

Book1
	A	B	C	D
1	Y	Status	Count	% of Total
2	N	Yes	4	57%
3	NA	No	3	43%
4	Y
5	N
6	NA
7	Y
8	N
9	NA
10	Y
Sheet1

HTH,

 

[iliace]

Look into COUNTIF and COUNTA functions.

 

[TheNoocH]

may not be the best way but should work

=COUNTIF(A1:A10,"Y")/(COUNTIF(A1:A10,"Y")+COUNTIF(A1:A10,"N"))

Book1
	A	B	C	D
1	Y
2	N
3	Y
4	NA
5	N
6	Y
7	N
8	Y
9	NA
10	Y
11
12	0.625
Sheet1

 

[domdc1]

EXCELLLLLLLLENT !!!!!

thanks for the help