Yes, there is a way to use the AVERAGE function to exclude the #N/A errors. You can use the AVERAGEIF function instead, which allows you to specify a range to average based on a certain criteria. In this case, you can use the criteria "< #N/A" to exclude the #N/A errors.

Here are the steps to use the AVERAGEIF function:

1. Select the cell where you want to display the average.
2. Type "=AVERAGEIF(" in the formula bar.
3. Select the range of cells you want to average (in this case, it would be Col E).
4. Type "," in the formula bar.
5. Type "< #N/A" in the formula bar (without the quotes).
6. Type ")" in the formula bar.
7. Press Enter.

The formula should look something like this: =AVERAGEIF(E:E,"< #N/A")

This will calculate the average of the values in Col E, excluding any cells that contain #N/A errors.