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.
Bookmarks