指定項目 大於0佔比率 (14669)

A3:A9=COUNTIFS($B$2:$CC$2,$A$2,B3:CC3,">0")/COUNTIFS($B$2:$CC$2,$A$2,B3:CC3,"<>")

格式化B2:P9=(B$2=$A$2)*(B2>0)