You also may try {=SUM(SMALL(D2:I2;ROW(INDIRECT("A1:A4"))))} entered for array-evaluation again, where the four consecutive ranks are generated by the ROW function applied to a range spanning from row 1 to row 4.
You also may try {=SUM(SMALL(D2:I2;ROW(INDIRECT("A1:A4"))))} entered for array-evaluation again, where the four consecutive ranks are generated by the ROW function applied to a range spanning from row 1 to row 4.