Hi. That totally worked!

Last question: when values to be averaged are not entered and cells are consequently left blank, there are divide by zero error messages showing. Only when I enter at least one value does the result display and these error messages disappear.

In the following formulas, is there a way to show a blank cell, not a divide by zero error, when no values to be averaged are entered?

=ROUND(AVERAGE(Q5:Q7),1)
=Vlookup(Q8, $B$38:$C$78,2,)

Screen Shot 2016-11-08 at 7.38.24 AM.png