I need help with Array formula??

Step by step instructions in post #3 were exactly right. You just needed to follow them, just put the START of each tier around the table to indicate the ranges. Then the formula as given worked fine. I've cleaned up the first two tables at the top for proper table layout and show an example below them using the data. You can repeat that with the other sections.