'Excel SUMPRODUCT to rank , duplicating same rank for the product

I have a list of products that are sold in different regions. To find top opportunity though, I need to look at the National level. I am trying to rank product using sumproduct with countif but not getting desired result.

enter image description here

I have used following formula

ROUND(SUMPRODUCT((E3<$E$3:$E$11)/COUNTIF($B$3:$B$11,B3))+1,0)

Please help how can I achieve the required result



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source