Reference a cell value in a formula

  • Thread starter Thread starter Leon
  • Start date Start date
L

Leon

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
 
=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
 
Back
Top