By using ranges of different dimensions (e.g., A2:A289, C2:C290), the
product of the array will contain #N/A (e.g., the 289th element for the
two ranges above). This is passed through to SUMPRODUCT's result.

As a first step, try changing C2:C290 to C2:C289.

In article ,
cursednomore wrote:

I used
=SUMPRODUCT((data!$A$2:$A$289=records!$A2)*(data!$ C$2:$C$290=records!$
C2)*(dat a!$D$1:$BC$1=records!$B2)*(data!$B$2:$B$289=record s!$D$1)).
This was to get the orders. Can you tell me where I went wrong, or if
I'm using the wrong function?