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