I have a form that is a series of questions regarding requirements. Some requirements will apply to some sites and some will be N/A for some sites depending on what each site is set up for. When a requirement does apply, there will be a scoring system associated with each requirement which will result in an adherence score at the end. The score needs to only count the requirements that apply, and not count the N/A options. How can I use the formulas COUNTIFS and ISNUMBER correctly to achieve this? Here are the columns I'm looking at and I'm trying to determine the Max Possible points by only counting the cells that have a number value (excluding the N/A) and multiplying by 3 (since that is the highest score that can be achieved):
The end idea is to sum all the values in Score Total (I know how to do that formula). And then that Score Total divided by the Max Score Possible will give the adherence score (which I know how to do as well). Remember, that each site will have varying N/A responses so I need to figure out the correct formula that will cover all scoring possibilities.
