As Dave has already mentioned, it would be best to trap the errors in
the first place, if possible. Otherwise, try...

AE4:

=SUMPRODUCT(SUMIF(INDIRECT({"AC4","AC40","AC85","A C94","AC121","AC139","A
C175","AC202","AC220","AC247"}),"<#DIV/0!"))

AF4:

=SUMPRODUCT(COUNTIF(INDIRECT({"AC4","AC40","AC85", "AC94","AC121","AC139",
"AC175","AC202","AC220","AC247"}),{"<0";"=0"} ))

AG4:

=AE4/AF4

Hope this helps!

In article ,
tamiluchi wrote:

I got some help yesterday with an average issue.
I'm attempting to average specific cells not in a range while ignoring div/o
errors.
This is what I'm using:
=AVERAGE(if(ISERROR(AC4,AC40,AC85,AC94,AC121,AC139 ,AC175,AC202,AC220,AC247,AC2
74),"",(AC4,AC40,AC85,AC94,AC121,AC139,AC175,AC202 ,AC220,AC247,AC274))(AC4,AC4
0,AC85,AC94,AC121,AC139,AC175,AC202,AC220,AC247,AC 274))
I can't make it work. What's wrong with it?
Thanks,
Tammie