M2单元格公式=SUM(COUNTIFS(B2:K2,{"√","换","年","值"},B3:K3,"<>"))*0.5+(10-SUM(COUNTIFS(B2:K2,{"√","换","年","值"},B3:K3,"<>")))*1
你的合并单元格可以取消的话可以写函数，若不能就只能写VBA ~若需要可以帮忙你写
