You can use a dynamic range.

Are there any empty cells *within* the range I5:I2000? It looks like that
range contains numbers, are there any text entries in that range?

--
Biff
Microsoft Excel MVP


"Ayo" wrote in message
...
Is there a function in excel that would allow me to replace the $2000 in
the
formular below with the last row in the column contain values.
Somthing like this, in VBA:
errorWS_lastRow = errorWS.Cells(Rows.Count, "A").End(xlUp).Row

=SUMPRODUCT((Current_MarketList!$I$5:$I$2000<$T$5) *(Current_MarketList!$K$5:$K$2000="PAST
DUE"))