Use the appropriate nested functions: If the employee Last name ends with a E or N, or R, or M, and begins with M or S or T, calculate the employee's highest Units Sold for Qtr 1, Qtr 2, Qtr 3 and Qtr 4 (L15:O15), otherwise the cell should be blank. Copy the function down to the other cells in the column.

In U10 use the appropriate function to calculate the total units. Format comma style 0 decimal.