Numbers: Count number of payments, SumIf, CountIf, Concatenate Date, change data types
I found the solution:

=SUMIF(2:2,CLEAN("&lt;="&amp;DATEVALUE(B5)),Pmt)



The solution was the proper use of the Clean() function.

I'll Leave this up if anyone has a similar issue.