data validation question

Hello,

I'm new to Excel and I've just figured out how to use Data Validation to create these handy dropdown boxes, at any rate here is my question:

Is there a formula that I can use that takes the information from a column (or row) that has data validation boxes w/ either a "yes" or "no" option and have it return the % of "yes" and "no" answers.

I'm not sure if that makes any sense, but...if have a list of 72 items and in columns C1-C72 have the data validation boxes in them, and 40 are selected as "yes" and 32 are selected as "no", is there a formula I can use to have box C73 tell me the % of 'yes" answers and box C74 tell me the % of "no" answers.

Any help would be greatly appreciated.

Kind regards,

Try:

=COUNTIF($C$1:$C$72,"yes")/COUNTA($C$1:$C$72)

and

=COUNTIF($C$1:$C$72,"no")/COUNTA($C$1:$C$72)

You're welcome!

You can use data validation for that too!

select the range next to the range that has the yes/no dropdown.

let's say as in your first example, this range is D1:D27.

After selecting the range go to Data|Validation and choose Custom from the Allow menu. In the formula field enter: =C1="yes"

where C1 is the top most cell in the yes/no range.

Now if the user selects "no" in C1 and tries to type something in D2, he will get an error message.....

Note: this error message is editable to your taste via the other tabs in the Data Validation dialogue box.