Unfortunately, it won't work even with that restriction.

Sumproduct can not be evaluated as an array formula (as you are trying to
do) by using application.Sumproduct in VBA.
You will need to build the formula the same as you would in a worksheet cell
and use the evaluate function

If Evaluate("SumProduct(--(A1:A500=B1:B500), --(C1:C500 < """"))") = 0 Then

demo's from the immediate window:

? Evaluate("SumProduct(--(A1:A500=B1:B500), --(C1:C500 < """"))")
2

two is the expected answer for the test data I set up.

--
Regards,
Tom Ogilvy


"daddylonglegs"
wrote in message
news:daddylonglegs.23597y_1139794201.5387@excelfor um-nospam.com...

For SUMPRODUCT to work a and c should not be whole columns and must be
the same size


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile:
http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=511574