Maybe you can adapt this method : https://community.glideapps.com/t/workaround-countif-in-a-row/27802