Hi All

I'm trying to do a SUMPRODUCT on a filtered range. The filters are on a date range in column B example 19/07/10 - 15/08/10 and where Column U = 1. Basically I want to count the number of times a certain category appears within this date range and where Column U = 1...the categories reside in column P and an example of some are "Powerpact", "Coupler" etc.

I've tried this but it doesn't work

=SUMPRODUCT((B3:B5231>19/7/2010)*(B3:B5231<=15/8/2010)*(P2:P5231="Powerpack")*(U2:U5231 = 1)))

Any help on this would be much appreciated

Regards

Donal