Rework a formula to only count "No" and "N/A" responses

HansVogelaar You helped me write a formula a while back in the attached example. In cells C33 and D33 the formula assigns a number value to each of the Probability and Severity words in columns C and D and then averages those numbers to come up with an overall Probability and Severity at the bottom of columns C and D. Is there a way to rework this formula to only use the equation if the answer in column B is "No" or "N/A"? The reworked formula in C33 and D33 should read something like, "If there is a "No" or "N/A", perform the calculation. If "Yes" or "Waiver" is selected, then do not include in the calculation.