It works for me. Have a look at the data itself, has it been imported from
somewhere? It's hard to say without looking at it but your formula is sound.
Regards,
Alan.
"goss" wrote in message
oups.com...
Hi all -

My sumproduct formula is measuring 2 criteria
-Values < 0?
-Period = P1

But it is returning a #N/A error
Can anyone give me a nudge in the right direction?

=SUMPRODUCT((Data!$D$2:$D$20000)*(Data!$E$2:$E$20 00=Summary!$K$2))/
1000

Thanks.
Best regards,
markc