SUMIFS with multiple criteria and date ranges

I have a sales history report that comes from webquery linked to an ERP system. I am trying to compile sales by person by month from a large data set. The attached spreadsheet is a sample set of data with an attempt to create the formula. There are two tabs, Results and Totals. I have my sample formula highlighted with an explanation in the Totals tab. Here is what I've tried but my results come back with #value! error, cannot find the error...

=SUMIFS(Results!E2:E3086,Results!C:C,">="&T2,Results!C:C,"<="&U2,Results!D:D,Totals!$A2)

The ranges must be the same size, so change the first to E:E.

Hope this helps.

Pete

Q2 cell formula

HTML Code: