Nested IF statement assistance

[kschmit1]

Hello,

I am attempting to limit the number of hidden cells and formulas in an existing workbook to avoid any potential deletion of cells on accident. (I will be protecting the document but this is an annual log, so I am thinking long term accident)

In an original version of this workbook I had Countif statements to total all the high, medium, and low failures where I still have High listed. I was able to remove the medium and low totals and move the formulas into the Success Rates portion because they are called out per file. High risks however are not totaled in that section separately but as one lump sum.

I am trying to determine if there is anyway I can combine the formula being used in Rows 39 and 40 to render the same results without two separate lines. Any ideas? Or will I need to leave this as it is currently?

The basic criteria for pass fail is listed at the upper portion of the document as well as in the formulas.