Sum across sheets

S

Steve

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!
 
D

Don Guillett

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top