software

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$2000gt;quot;01/01/2006quot;),--('Laptops -
All'!$AD$2:$AD$2000=quot;BRENNAN JRquot;))

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

Hi!

gt; 1. Less than 01/01/2006
gt; 5 Greater than 10/01/2006

Those 2 ranges are pretty wide open!

Create a small 2 column table:

A1 = 0 | B1 = 12/31/2005
A2 = 1/1/2006 | B2 = 3/31/2006
A3 = 4/1/2006 | B3 = 6/30/2006
A4 = 7/1/2006 | B4 = 9/30/2206
A5 = 10/1/2006 | B5 = 100000

Then you can just refer to the appropriate range of cells:

=SUMPRODUCT(--($X$2:$X$2000gt;=A1),--($X$2:$X$2000lt;=B1),--($AD$2:$AD$2000=quot;BRENNAN
JRquot;))

Biff

quot;msbutton27quot; gt; wrote in message
...
gt; Hey all,
gt;
gt; I have a SUMPRODUCT equation (below) in which I want to look for a
gt; specific
gt; name and then check the date column to see if the date is in Q1, Q2, Q3,
gt; etc...
gt;
gt; This is what I have:
gt; =SUMPRODUCT(--('Laptops - All'!$X$2:$X$2000gt;quot;01/01/2006quot;),--('Laptops -
gt; All'!$AD$2:$AD$2000=quot;BRENNAN JRquot;))
gt;
gt; Not working for me, returns all 0's - what can I do to specify
gt; 1. Less than 01/01/2006
gt; 2. Between 01/01/2006 - 03/31/2006
gt; 3. Between 04/01/2006 - 06/31/2006
gt; 4 Between 07/01/2006 - 09/31/2006
gt; 5 Greater than 10/01/2006