I figured out that the SUMPRODUCT formula would work best in my situation and
it did....however i made a slight error when writing it and now i'm
stuck...the currents formual looks like this...

=SUMPRODUCT(--(MONTH(Data!$G$2:$G$47)=2),--(YEAR(Data!$G$2:$G$47)=2006),--(Data!$D$2:$D$47="Purchased"))

however when dealing with my data, i need it to search between two
dates....for example the date would be anything between Jan 1, 2006 and Jan
20, 2006.WOuld the formual look somehting like this??

=SUMPRODUCT(--(DATE(2006,1,1<Data!$D$2:$D$47<2006,1,20)),--(Data!$D$2:$D$47="Purchased"))

Thank you!

--
--Chip Smith--
MVP Wannabe :)