Try

=SUMPRODUCT((Current_MarketList!$I$5:OFFSET($I$1,0 ,0,MATCH(1E+300,$I:$I))$T$5)*(Current_MarketList! $K$5:OFFSET($I$1,0,2,MATCH(1E+300,$I:$I))="PAST DUE"))

Hope this helps,

Hutch

"Ayo" wrote:

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"))