Excel(WPS form) voting score accounting formula

1. You cancel the merger of M4 and M5 first, and then enter the total score formula = sum (D5: L5)-indirect (address (3, min (if (D4: L4)

2. The formula of the total number of votes is written in N4 as the formula =SUM(D4:L4)-2.

3. The formula of average score is to write the formula =TEXT(M4/N4, "0.0") in O4.

4. Drag and drop the above three formulas into the cell you need.