Excel's OFFSET function lets you create a reference that ... and the total and average units sold by that employee (using SUM and AVERAGE with OFFSET). First, I will type an employee ID into ...