If they are proper dates all you need is

=SUMPRODUCT(--(B2:B347=D349),--(B2:B347<=D350),--(ISNUMBER(SEARCH("39BD382",C2:R347))))


--
__________________________________
HTH

Bob

"LouD" wrote in message
...
Hello,

I have been searching this forum all day and I can't seem to get any code
that I find to work. Below is what I believe should work. Cell D349 has
3/1/2007 and cell D350 has 3/31/2007.

=SUMPRODUCT(--(B2:B347=--D349),--(B2:B347<=--D350),--(C2:R347="39BD382*"))

What I'm basically lookinf for is: if the part number 39BD8382 is present
anywhere in cell range C2:R347, how many shipped in March of 2007?

Thanks in advance.