O
ocuhcs
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?
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?