Too late to help you... but I have the same issue today (in 11/2010)... and after coming up empty handed on a web-search for solution... I figured the solution by writing a Array formula =RSQ(if(iserror({range1}),"",range1),if(iserror(range2),"",range2))... it gives the correct answer.