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