Troubleshooting Instagram Follower Ranking Issues in Excel

Not sure if this is the right place to post, but I'm having difficulty ranking instagram followers based on defined thresholds that I've set. I created a quick video covering what I'm running into, but essentially when I run the sample output everything calculates properly, but when I run the workbook everything in all cells calcs out to just 1. Any help would be greatly appreciated! https://www.loom.com/share/85a10cb65ebe4e6284f0dcc458e0a6e3?sid=e462045d-bc51-4f87-966a-f5edcafadc03