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.

0 total posts (Page 1 of 1)  
Thread display: Collapse - | Expand +

All Answers

Share your knowledge
Back to Software Forum
0 total posts (Page 1 of 1)  

Related Discussions

Related Forums