Would you mind explaining the formula

What are the values at the end ,2,99

The IF(LEFT(A1:K1)="H" compares the

**left**most symbol of the text string from each cell in range

**A1:K1** with the letter "

**H**"

If the result of this comparison is TRUE, the MID(...) function is invoked ind its result is returned. Otherwise, the IF(...) returns FALSE.

The 2 and 99 are arguments of the MID(...) function. They say: return up to

**99** symbols of the string starting from position

**2**.

In our case, MID("H8.5",2,99) returns text string "8.5".

The '--' converts the text string "8.5" into number 8.5, and all FALSE's into 0's.

Finally, the SUM function add together elements of the resulting array {0,0,0,0,8.5,0,0,0,0,0,0}.