Question

Locked

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

=AVERAGEIF(F9:F573,F9,BD9:BD573)

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

thanks

Stuart

This conversation is currently closed to new comments.

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

All Answers

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

Related Discussions

Related Forums