I have the following formula:

=SUMPRODUCT((MONTH(Summary!$F$7:$F$15000)=1)*1)

I want the "15000" to be replaced by the varaible value of a cell in an
other worksheet ("Summary").

I tried using INDIRECT but it didn't work.

Thanks in advance