Sumproduct with dynamic array

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)))

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

$F$3 curently equals August they are the names of the months not a date field

Originally Posted by benaw

$F$3 curently equals August they are the names of the months not a date field

In that case try like this

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