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