Input value of cell into formula

[EssKayKay]

I’m looking for a way to include the value of cell in the following formula.

=SUMPRODUCT(--(YEAR($C$33:$C$200)=R33))

The range($C$33:$C$200) varies. The range always starts in cell C33 but the end row varies (always column C). The end row value resides in Cell T13. Therefore, in the above formula the $200 is where I want to insert the value in T13 rather than hard code in a location. That is, if I want the range to be C13:C477 where the value in cell T13=477.

Thanks for viewing,
Steve

 

[Fluff]

How about

=SUMPRODUCT(--(YEAR($C$33:INDEX($C:$C,T13))=R33))

 

[EssKayKay]

How about

=SUMPRODUCT(--(YEAR($C$33:INDEX($C:$C,T13))=R33))

Thank you Fluff this is what I was looking for.
Much appreciated. . .
SKK

 

[Fluff]

You're welcome & thanks for the feedback.