Sum across sheets

I would like to sum yes/no responses for individuals across multiple sheets.
- 10 identical sheets
-Column A header is Name
-Drop down with a list of names to select
-Column B header is Yes
-Input is “x� or blank
-Column C header is No
-Input is “x� or blank
For example:
If Pat Jones is selected in Sheet 1, return the number of yes or no
responses in a separate summary sheet for Pat Jones
If Steve Smith is selected in Sheet 2, return the number of yes or no
responses in a separate summary sheet for Steve Smith.
If Steve Smith is selected in Sheet 3, sum yes or no responses and return
sum of Sheet 2 and 3 responses in summary sheet for Steve Smith
Thanks for the Help!

If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Steve" wrote in message
...
I would like to sum yes/no responses for individuals across multiple
sheets.
- 10 identical sheets
-Column A header is Name
-Drop down with a list of names to select
-Column B header is Yes
-Input is “x� or blank
-Column C header is No
-Input is “x� or blank
For example:
If Pat Jones is selected in Sheet 1, return the number of yes or no
responses in a separate summary sheet for Pat Jones
If Steve Smith is selected in Sheet 2, return the number of yes or no
responses in a separate summary sheet for Steve Smith.
If Steve Smith is selected in Sheet 3, sum yes or no responses and return
sum of Sheet 2 and 3 responses in summary sheet for Steve Smith
Thanks for the Help!