If Statement and Average

[beachlabrat]

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

[arthurbr]

Welcome to the board
Perhaps something like :

Please Login or Register  to view this content.

where list is your range
entered as an array with CTRL+shift+enter

[beachlabrat]

I kind of used the idea that you sent me arthurbr, but this is the actual formula I used:
=If(l14>0,(l15>0),average(l14:l15,"")

What i need it to do is put a value in cell m15 of the averaged value(s).

Thank you for any further assistance you may be able to provide.