We must use SUBTOTAL and OFFSET in Office 2019 because it lacks the dynamic array formula in order to return an array of the MINIMUMS of each row to SUMPRODUCT. Add the following criteria to SUMPRODUCT after that:
One note, for me the numbers transferred as text not numbers. Make sure they are true numbers or this will not work.
For those with the Dynamic Array formula we can ditch the Volatile Offset: