change your formula to

=IF(Totals!B40,Concatenate(Totals1B4,"-",Totals!B$3),"")


--
PF Wannabe
------------------------------------------------------------------------
PF Wannabe's Profile: http://www.excelforum.com/member.php...o&userid=25798
View this thread: http://www.excelforum.com/showthread...hreadid=391989