Yes / No sum

[timboellis]

Can anyone tell me how to in a worksheet:

Have serveral yes no drop down options, and with these have a sum at the end that says 2 yes's and 4 no's or something lke that

 

[Oaktree]

How are your drop downs set up? Are they data validated cells? Are they combo boxes--if so, are they linked to cells?

 

[Von Pookie]

This work for you?

Book1
	A	B	C	D
1	No		Totals
2	No		Yes	2
3	Yes		No	4
4	No
5	Yes
6	No
Sheet1

 

[timboellis]

All i have done is setup 2 boxes saying Yes no, i put these n by clicking the cell then secting Data>validation>List>Yes,No

 

[timboellis]

Yeas thanks for that it works berfect BUT........

I assume this will still work if i have the yes/no's scattered all over the worksheet and if so how do i do it.

 

[Von Pookie]

You just change the range that is being looked at. So in the example I posted above, the function is only counting instances of Yes or No in range A1:A6.

If you want to count all the instances within, say, A1:G10, you would simply enter that range in place of A1:A6.

 

[timboellis]

Excellent thanks for that