I read the Help for AVERAGEA and found this note:
"Arguments that are error values or text that cannot be translated into
numbers cause errors." The #DIV/0 constitutes an error value, so this
may be the culprit. Can you post a sample of your data, showing what
you have and what you expect to get?

You may be able to work around the #DIV/0 if an appropriate IF formula
(If the divisor is zero, return zero or nothing; if the divisor is not
zero, perform the division).