Need help with Formula to change multiple cell's values - Example Attached

I have an issue that's fairly complex, for me at least, and was hoping someone count help me get started here.

I've attached a detailed example of what I need, but basically here is issue:

IF a cell, which is a drop down, equals a certain text value, then I need a range of cells in the adjacent column to all equal 0.

Here's where it get's complicated.

IF there are 3 or more of the word "Minor" in a range of cells, then then all of the adjacent cells need to equal 0.

IF there are 2 or more of the word "Major" in a range of cells, then all of the adjacent cells need to equal 0.

IF the selection is "Critical" in any cell in the range of cells, then all of the cells in teh adjacent column should be 0.

IF "Good Practice" then 5 only in adjacent cell.

The Example attached makes it a lot easier to understand what I'm trying to do here, but here is a simple table to illustrate, and there are a few more conditions as well.


A B
Good Practice 5
Major 5
Good Practice 5
Good Practice 5
Major 5


So since there are two occourences of the word "Major" in A1 to A5, then B1 through B5 should all equal 0, regardless of any other values.

Thanks in advance, I'll mark this resolved and give good rep if anyone can help!