Coding in excel across sheets

I am creating a Risk Catalog for a project. I have one sheet in Excel titled "Risk Log". In that sheet one column is labeled "Impact" (with the options to select Negligible, Marginal, Severe, Critical, or Catastrophic) and another one is labeled "Probability" (with the options to select Very Unlikely, Unlikely, Possible, Likely, or Very Likely). I also have another sheet labeled "Risk Metrics" shown here: The table to the left indicates the Priority order for all risks based on their Impact & Probability, and the table to the right is what I am trying to work with. As you can see, the tiny table on the bottom calculates how many risks are "Green, Yellow, and Red" based on the table. That code has already been set. However, I am having trouble populating the table to the right. What I would like to do, is for the table on the right to indicate how many risks fall into each category (AKA how many risk are "Severe & Likely" or any combination: For example if only 1 risk was both Severe AND Likely, that cell would say 1, and 2 if two risks were that combination) I would like to use an IF AND statement that would cover all the risks that are in my Risk Log (could be up to 100)

Thank you very much!!

Here in an example of what the Risk Log might look like when completed.