You should really fix the errors since if you do you can use both ranges in
an average formula

=SUM(SUMIF(D4:P4,"<#DIV/0!"),SUMIF(U4:AG4,"<#DIV/0!"))/MAX(1,SUM(COUNTIF(D4:P4,"<#DIV/0!"),COUNTIF(U4:AG4,"<#DIV/0!")))

will work (replace #DIV/0! with the error you can have) but it will fail if
you have empty cells since they will be counted


--
Regards,

Peo Sjoblom

Northwest Excel Solutions

Portland, Oregon




"joshkraemer"
wrote in message
...

I'll make this short and brief.

Here's what works:

{AVERAGE(IF(ISERROR(D4:P4),"",D4:P4))}

Here's what I want to do (but doesn't work):

{AVERAGE(IF(ISERROR(D4:P4,U4:AG4),"",D4:P4,U4:AG4) )}

What am I doing wrong? I want to be able to ignore all errors when
calculating an average for _multiple_(2)_ranges_ (D4:P4 and U4:AG4, not
just D4:P4).

Thanks in advance for the help.


--
joshkraemer
------------------------------------------------------------------------
joshkraemer's Profile:
http://www.excelforum.com/member.php...o&userid=31508
View this thread: http://www.excelforum.com/showthread...hreadid=511845