Excel will automatically tell me the employee's name (using the VLOOKUP function), the total number of weeks of data we have (using the COUNTIF function), and the total and average units sold by ...

Here's how the INDIRECT function will help us to do this. Start by typing =AVERAGE(INDIRECT in cell E2, because we're telling Excel that we ultimately want to find an average, and we're also using ...