Math needed in glide for fast results.
Convert this to inglide math.
COUNT/COUNT UPC IN ORDER DOWN
=ARRAYFORMULA(IF(K2:K<>“”,COUNTIFS(K2:K,K2:K,ROW(K2:K),“<=”&ROW(K2:K)),“”)-1)
COUNT/COUNT DDNS
=ARRAYFORMULA(IF($K2:$K<>“”,COUNTIFS($B2:$B,$B2:$B,ROW($B2:$B),“<=”&ROW($B2:$B)),“”))
COUNT/COUNT UPC On JOB SITE
=ARRAYFORMULA(if(ISBLANK(B2:B) <= false,COUNTIFS($K2:$K&B2:B,“”&$K2:$K&B2:B,ROW($B2:$B),“<=”&ROW($B2:$B)),0))
COUNT/JOB SITE TOTAL
=ARRAYFORMULA(if(ISBLANK(B2:B) <= false,COUNTIFS($K2:$K&B2:B,“”&$K2:$K&B2:B,ROW($B2:$B),“<>”&ROW($B2:$B))+1,0))
COUNT/ALL TOTAL PRODUCT
=ARRAYFORMULA(IF(K2:K<>“”,COUNTIFS(K2:K,K2:K,ROW(K2:K),“<>”&ROW(K2:K)),“”))