[SOLVED] SUMPRODUCT with DYNAMIC range

Hi All

I have the following formula which is copied down from cell A4 but now the INDEX range number of rows will change every week. Can this formula be modified to find the last row?

=SUMPRODUCT(MAX((EUT!$B$2:$B$10000=$C4)*(EUT!$C$2:$C$10000=$U$3)*(EUT!$F$2:$F$10000)))

Thanks