If Statment To Find Percent Based On Yes Or No

[rockyw]

I have a list of 13 columns that could be yes or no. I need the percent that is marked as yes. Can I use an IF formula?? The formula will be in D6 looking at F14:F26, Thanks

 

[Robert Mika]

=COUNTIF($F$14:$F$26,"yes")/ROWS(F14:F26)

 

[rockyw]

Thanks that worked. Now can I use this formula to find the values in column E that go with the names in column B, is this close? Thanks

=SUM(($E$14:$E$26)*($B$14:$B$26=A6))

 

[rockyw]

I have this formula that I need to change to row 26, when I do that I get an error. Why would this happen? Thnaks

=SUM(($F$14:$F$25="yes")*($B$14:$B$25=A6))

 

[Robert Mika]

Thanks that worked. Now can I use this formula to find the values in column E that go with the names in column B, is this close? Thanks

Like this?
Excel 2010

	A	B	E
12	6
13
14		yes	1
15		yes	1
16		yes	1
17		no	1
18		no	1
19		no	1
20		no	1
21		no	1
22		no	1
23		no	1
24		yes	1
25		yes	1
26		yes	1

<colgroup><col style="width: 25pxpx"><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet1​

Worksheet Formulas Cell Formula A12 =SUMIF($B$14:$B$26,A6,$E$14:$E$26) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

Not sure about the second request.
Do you want to count all occurance of A6 in column B that match "yes" in column F?

 

[rockyw]

That works great,now can I add one more thing. Can I base that off in column F is a Yes or No. I have this so far.

=SUM(($F$14:$F$26="yes")*($B$14:$B$26=A6,E14:E26))

Is this close? Thanks

 

[rockyw]

=SUM(($F$14:$F$25="yes")*($B$14:$B$25=A6))

Yes all I want to do is add one more row, to 26 but the formula stops working when I do that. I don't understand that?

 

[rockyw]

Bump, can anyone help with this please? Column F has Yes or No, column B has names, A6 has one of the names in B. If column F has a yes for the name in A6 the formula adds the sum in column E for that name. So if there are 3 of the same name it adds all the sums behind he name in column E. I had this but will not work. Thanks

=SUM(($F$14:$F$26="yes")*($B$14:$B$26=A6,E14:E26))</PRE>

 

[Robert Mika]

Excel 2010
	A	B	C	D	E	F
5		Excel 03/07/10	Excel 07/10	Excel 03/07/10
6	robert	1	1	1
7
14		Joe			1	yes
15		Robert			1	yes
16		Jerry			1	yes
17		Robert			1	no
18		Joe			1	no
19		mama			1	no
20		kasia			1	no
21		Joe			1	no
22		Gui			1	no
23		papa			1	no
24		mumu			1	yes
25		ffuf			1	yes
26		mama			1	yes
Sheet1

Cell Formulas
Range	Formula
C6	=SUMIFS(E14:E26,$F$14:$F$26,"yes",$B$14:$B$26,A6)
D6	=SUMPRODUCT(--($F$14:$F$26="yes"),--($B$14:$B$26=A6),E14:E26)
B6	{=SUM(IF($F$14:$F$26="yes",IF($B$14:$B$26=A6,E14:E26)))}
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[rockyw]

Thank you for the help. I never worked with an Aray before. Thanks