Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I print sheets in Excel without blank sheets after page | New Users to Excel | |||
Multiple Sheets (Need to create 500 individual sheets in one workbook, pulling DATA | Excel Worksheet Functions | |||
How to repeat a code for selected sheets (or a contiguous range of sheets) in a Workbook? | Excel Worksheet Functions | |||
In 3 active sheets in wkbk, determine& display the # of sheets that have data | Excel Discussion (Misc queries) | |||
populating sheets based on data from parent sheets | Excel Discussion (Misc queries) |