raisedwell
New Member
- Joined
- Mar 4, 2010
- Messages
- 22
I need help with a formula that would allow me to determine the following:
I have a workbook where am using Sheet1 as a dashboard that will help determine how many questions were not answered found on Sheet2.
Scenario:
Sheet 2 has a comprehensive list of questions to which Column A contains the list of 50 questions, Column B should contain 50 responses. If they they provide YES to the first question, (Sheet2, B1) then the rest of the questions are out of scope and should not be counted, otherwise, if the first question is answered NO, then count the number of blank cells between Sheet2, B1 thru B50
I can obtain the number of blank cells by using =COUNTBLANK(Sheet2!A1:A50) however, I cannot figures out how to add a condition of making the remaining questions out of scope if the first question is answered YES.
Thanks in advance for any help provided.
I have a workbook where am using Sheet1 as a dashboard that will help determine how many questions were not answered found on Sheet2.
Scenario:
Sheet 2 has a comprehensive list of questions to which Column A contains the list of 50 questions, Column B should contain 50 responses. If they they provide YES to the first question, (Sheet2, B1) then the rest of the questions are out of scope and should not be counted, otherwise, if the first question is answered NO, then count the number of blank cells between Sheet2, B1 thru B50
I can obtain the number of blank cells by using =COUNTBLANK(Sheet2!A1:A50) however, I cannot figures out how to add a condition of making the remaining questions out of scope if the first question is answered YES.
Thanks in advance for any help provided.