=AVERAGE(INDIRECT . in cell E2, because we're telling Excel that we ultimately want to find an average, and we're also using the INDIRECT function to tell Excel where to look to calculate this ...

The Excel INDIRECT function is a Lookup and Reference function, and its purpose is to return the reference specified by a text string. You can use the INDIRECT function when you want to change the ...