Excel中如果数值为√，则某单元格加1，数值为0.5则单元格加0.5

Question

Excel中如果数值为√，则某单元格加1，数值为0.5则单元格加0.5,如下图

Answer 1

=SUMPRODUCT((D5:AH5="√")+(D5:AH5=0.5)/2)
回车确认后下拉填充。

Answer 2

=COUNTIF(E5:AH5,"√")+COUNTIF(E5:AH5,">0")*0.5
下拉公式

Answer 3

＝COUNTIF(D5:H5,"√")+COUNTIF(D5:H5,0.5)*0.5