Question Locked
Excel AVERAGEIF - ignoring blanks, zeros & errors
0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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