=SUMPRODUCT((MONTH(OFFSET(Summary!$E$7,0,0,C4,1))= 1)*1)

C4 in this case is the cell that holds the number of items to be used in the
calculation
--
If the post is helpful, please consider donating something to an animal
charity on my behalf ..... and click Yes


"Leon" wrote:

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