As I said, the easiest way out for you would be to evaluate the result
of the array formula. As I don't know what exactly is happening, I can
only suggest this method:
=IF(ISNUMBER(SUM((Lantigua!$C$2:$HJ$2=DATEVALUE(" 1-Jan"))*(Lantigua!$C$2:$HJ$2<=DATEVALUE("31-Jan"))*(Lantigua!$C$5:$HJ$5))),SUM((Lantigua!$C$2: $HJ$2=DATEVALUE("1-Jan"))*(Lantigua!$C$2:$HJ$2<=DATEVALUE("31-Jan"))*(Lantigua!$C$5:$HJ$5)),"")
Mangesh
--
mangesh_yadav
------------------------------------------------------------------------
mangesh_yadav's Profile:
http://www.excelforum.com/member.php...o&userid=10470
View this thread:
http://www.excelforum.com/showthread...hreadid=378044