The numbers I want to total are in Column M

=SUMPRODUCT((Data!D$1:D$2550=Lists!A13)*(Data!D$1 :D$2550<Lists!B13)*(Data!J$1:J$2550="Saint Paul")*(Data!M$1:M$25500))

What I am trying to say is-

Look at the data in column D of the "Lists" worksheet. When the value of
the data (this happens to be a date) is = the first day of a given year, and
< the 1st day of the next year, and the city which is recorded in Column J is
"Saint Paul", please total the numbers in column M.

This doesn't seem to be working quite right though.