Hey all,

I have a SUMPRODUCT equation (below) in which I want to look for a specific
name and then check the date column to see if the date is in Q1, Q2, Q3,
etc...

This is what I have:
=SUMPRODUCT(--('Laptops - All'!$X$2:$X$2000"01/01/2006"),--('Laptops -
All'!$AD$2:$AD$2000="BRENNAN JR"))

Not working for me, returns all 0's - what can I do to specify
1. Less than 01/01/2006
2. Between 01/01/2006 - 03/31/2006
3. Between 04/01/2006 - 06/31/2006
4 Between 07/01/2006 - 09/31/2006
5 Greater than 10/01/2006