SUMIFS Formula with Dates Not Working

I'm trying to sum gross amounts (L13:L22) based on 2 criteria -- the first is if the amount is "line haul" (A13:A22) and second is if the date matches a certain MONTH (R13:R22 matches to S13). This is my formula, but it's producing a 0 result.

=SUMIFS(L13:L22,A13:A22,"Line Haul",R13:R22,"=S13")

In the attached spreadsheet the formulas are in U13 and U14 (on the 01-03-2020 & 01-10-2020 tabs)

I'm thinking the problem may lie with my date references (in columns S & R) ... but I'm stumped.

What am I doing wrong??

I had tried that one too, but it also produces a 0 result I just don't get it! lol

Hmmm, I thought I had a attached a workbook .. are you not able to see it?

Phew .. was getting worried there!! Thank you!!!

I thought it was just formatting ... Column R is General and Column S is mmm. Even if I change the formatting to match, it's not working ... AND the 12's change to Jan when the formatting is mmm. It's baffling!

I will be adding tabs to the workbook for each week. Within each week, I need to sum all the Gross Amounts for all "line hauls" that were delivered in the current month (U14) and the previous month (U13), based on the Settlement Date (H3) - which is a formula that matches the tab name. I will then be adding formulas in my YTD Summary to reference total line hauls for each month (this formula is not yet created).

OMG!!! THANK YOU, THANK YOU CARACALLA ---- that worked perfectly!!!!!! Wooohooooooo!!!

You are welcome

Since "Line Haul" may not always appear on the first row, I had to change your formula to the following ...

=IF($S13<>"",SUMPRODUCT(($A$13:$A$22="Line Haul")*($D$13:$D$22<>"")*(MONTH($D$13:$D$22)=MONTH(S13))*($L$13:$L$22)),"")

Even with this change, it works beautifully! Thanks again!!!