This is how it would be

=SUMPRODUCT(('YTD Bid Summary'!E6:E32--"2008-10-01")
*('YTD Bid Summary'!E6:E32<--"2008-10-31"),'YTD Bid Summary'!J6:J32)

--
__________________________________
HTH

Bob

"Stilmovin" wrote in message
...
Thanks Ashish Mathur, Fred Smith, Bob Phillips

This is the equation that i came up with that made it work
=SUMPRODUCT(('YTD Bid Summary'!E6:E32DATE(2008,10,1))*('YTD Bid
Summary'!E6:E32<DATE(2008,10,31)),'YTD Bid Summary'!J6:J32)

I tried to use Bob's equation for the date but that didn't work. Using the
Date function it pulled out the right numbers. Thanks for your help i will
be
comming back for any other problems that i have.


"Fred Smith" wrote:

Good point, Bob.

Regards,
Fred.

"Bob Phillips" wrote in message
...

"Fred Smith" wrote in message
...
Your formula fails, Ashish, because 10/1/2008 to Excel is 10 divided
by 1
divided by 2008. You need to use either Date(2008,10,1)
or --"10/2/2008"

If using that format, use a non-ambiguous date format else it fails on
some systems, that is

--"2008-10/02"