Hi Yunus,

It's an array formula. So you have to confirm with Ctrl+Shift+Enter.
i.e,
Hold down the Ctrl and Shift keys while hitting Enter key.


You can also try this,

=SUMPRODUCT(--('[SAP05.xls]May!$C$6:$C$231=$D$2),--('[SAP05.xls]May!$E$6:$E$231=$D72),'[SAP05.xls]May!$K$6:$K$231)

Normal Enter

HTH


--
Krishnakumar


------------------------------------------------------------------------
Krishnakumar's Profile: http://www.excelforum.com/member.php...o&userid=20138
View this thread: http://www.excelforum.com/showthread...hreadid=398525