Hello,

I'm trying to populate a field if a certain date range has a specific quality, e.g. between Jan 01 and Jan 31, cars sold that are red, provide the already summed total of red cars.

=SUMPRODUCT((DateRec>=DATE(2009,1,1)*(DateRec<=DATE(2009,1,31)*(P3:S3=AH4)*V4)))

It doesn't seem to be pulling the data.

Thanks