Now, we're ready to use the INDIRECT function to turn the data in cell E1 into a reference. At this point, our aim is to find the average of the values in cells B6 to B8.

Now we are going to look up the current sales using the R1C1-style reference method. Enter where you want to place the result; the formula is =INDIRECT (“R7C”&COUNTA (7:7), FALSE).