Excel AVERAGEIF - ignoring blanks, zeros & errors

By stuart.d.judd ·
Trying to average a column of data by a specified group, this gorup is hel in a different column. However the data must average all numbers whiclst ignoring blanks, zeros and errors. eg: #div/0!.. any ideas?

I have tried the simple tricks but cannot get it to work so here is the base formula


where F is the grouping code
F9 is the specified value
BD is the data range which includes, zeros and blanks and error codes



This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Share your knowledge

Related Discussions

Related Forums