I have this formula and what i'd like is be able to do is say Data_Month= dates between this and this so if i set it to september it would give me results from January to September.

=SUMPRODUCT(--(Data_Year=$B$3),--(Data_Month=$F$3),--(Data_Total_Lots=1),--ISNUMBER(SEARCH(B10,Data_Lot_No)))