If Statement and Average

I'm working on a spreadsheet for the lab. I have a standard that needs to be in the range of 167.5-228.5, I have an if statement to do this; If(k14>=167.5,(K14<=228.5)*$k$14,""), this works, what I need to do after this or add to this is to average the value(s) that are in column L without using an empty cell or using a zero value? Is this possible to do?

http://www.excelforum.com/showthread.php?t=398946

Thank you for your time and help in this matter. Any assistance is greatly appreciated. Merry Christmas to all. Please let me know if more information is needed.

Kim Anderson