=SUMPRODUCT(('Production Log'!$H$5:$H$7308=$C11),('Production
Log'!$K$5:$K$7308=H$8),('Production Log'!$J$5:$J$7308=H$9))

gives a "0"

Whereas,

=SUMPRODUCT(('Production Log'!$H$5:$H$7308=$C11),('Production
Log'!$K$5:$K$7308=H$8),('Production Log'!$J$5:$J$7308=H$9),1)

gives #VALUE

and my original formula
=SUM(IF('Production Log'!$H$5:$H$25000=$C11,IF('Production
Log'!$K$5:$K$25000=H$8,IF('Production Log'!$J$5:$J$25000=H$9,1,0))))

Was working fine. But I want to put this formula into Excel through the
script and this formula requires a CTRL+SHIFT+ENTER

and I gave a "SendKeys ("^+~"), True"

None of these seem to work...

Experts!! What do you have to say?


--
Baapi
------------------------------------------------------------------------
Baapi's Profile: http://www.excelforum.com/member.php...o&userid=27333
View this thread: http://www.excelforum.com/showthread...hreadid=470376