Try using

=STDEV('sheet1'!B2:H2,'sheet2'!B2:H2,'sheet3'!B2:H 2,'sheet4'!B2:H2)


--
tobriant
------------------------------------------------------------------------
tobriant's Profile: http://www.excelforum.com/member.php...o&userid=25155
View this thread: http://www.excelforum.com/showthread...hreadid=469179