Try...

=SUMPRODUCT(--('Wholesale Orders'!C2:C2000=A2),--('Wholesale
Orders'!G2:G2000=DATE(2008,1,1)),--('Wholesale
Orders'!G2:G2000<=DATE(2008,12,31)),'Wholesale Orders'!F2:F2000)

Hope this helps!

In article ,
ocuhcs wrote:

I am trying to keep a running sum of customer order amounts for a given year
to compare TY vs. LY using the following formula:

=SUMPRODUCT(--('Wholesale Orders'!G2:G2000<=DATE(2008,12,31)),--('Wholesale
Orders'!G2:G2000=DATE(2008,1,1)),--('Wholesale
Orders'!C2:C2000=A2))--('Wholesale Orders'!F2:F2000)

With the G column as the date range, C column as the customer name, and F
column as the $amount.

i do not get an error, but the formula result is an erroneous value. Do the
arrays in sumproduct need to fall in a specific sequence?