First off, thank you for your time.

I can create a sample sheet if needed but what I am trying to do is create a formula to average a range and ignore blanks but does not ignore zeros since I'll have those as values. I know how to do and averageif ignoring both blanks and zeros but not sure about just ignoring blanks.

I look forward to the learning lesson.