I need some advice to accomplish a calculation within a excel spreadsheet.
I have a worksheet that contains a table with couple questions, the columns headers are
Questions, Status, Weight and Comments. The weight value is a number from 1-5. The Status is where the user can select Yes, No or N/A as a response to the questions.
I have a ScoreCard worksheet, that contains a table with a reference to each of the worksheets in the spreadsheet that the user needs to respond and calculate the score. The score is calculated by counting all the Yes, responses with weight 1, all the NO responses with weight 1, all the N/A responses with weight 1 and etc. until all the Yes, No or N/A responses with weight 5 for that worksheet.
How I can create a formula for this?
Could I create something like From this Range (B4:B34) where Weight IsNot null count all Yes where Weight =1?
What I am looking for is a way to count for example from all the responses
Start Free Trial
