Yes or no percentage but not in cell range.

[boots647]

Hi all

I am trying to work out a formula that looks at 10 different cells that have a yes or no in it and I want to do a percentage of how many are yes.

So if 10 no then it'd be 0% if 1 no it'd be 90%.

I can't seem to work a formula out as all formulas I can think of only work with a cell list not cell here cell there ie. I'd have a yes in e12 then a yes or no in l13 then yes or no in t5 n I don't want it looking at cells in between these ones.

Hope this makes sense

Thanks

 

[kevin9999]

Book1
	A	B	C	D
1	Y/N		Percent Yes =	90%
2	No
3	Yes
4	Yes
5	Yes
6	Yes
7	Yes
8	Yes
9	Yes
10	Yes
11	Yes
Sheet1

Cell Formulas
Range	Formula
D1	D1	=COUNTIF($A$2:$A$11,"Yes")/10

 

[boots647]

My problem is the cells aren't in a range the are all over the place is there a way of doing this without the range?

 

[kevin9999]

An example without the range - although I'm sure there must be simpler ways.

Book1
	A	B	C	D	E	F	G	H
14	Percent Yes:	90%
15
16		Yes	Yes		No		Yes
17
18					Yes
19			Yes
20
21								Yes
22			Yes		Yes
23
24
25				Yes
26
Sheet1

Cell Formulas
Range	Formula
B14	B14	=SUM(COUNTIF(INDIRECT({"B16","C16","E16","G16","E18","C19","H21","C22","E22","D25","F25"}),"Yes"))/10

 

[boots647]

It's coming up #value

 

[kevin9999]

It's coming up #value

You need to put the cell addresses inside quotation marks

=SUM(COUNTIF(INDIRECT({"B16","C16","E16","G16","E18","C19","H21","C22","E22","D25","F25"}),"Yes"))/10

 

[boots647]

If I do that it then comes up there's is a problem with ur formula

 

[kevin9999]

I

If I do that it then comes up there's is a problem with ur formula

I've changed my formula to reflect the cells you seem interested in. Copy it & paste it into the cell where you currently have your formula.

=SUM(COUNTIF(INDIRECT({"J11","J17","J19","J24","J28","J34","J38","J47","J54","J75"}),"Yes"))/10

 

[boots647]

Perfect thank u so much not sure what I was doing wrong. Thanks again

 

[kevin9999]

Perfect thank u so much not sure what I was doing wrong. Thanks again

Glad we got there in the end, and thanks for the feedback
(you probably just missed out a quotation mark or comma somewhere - easy to do in long formulas)