Multiple Lookups Using =SUMIFS Returning #SPILL or 0

I am attempting to combine values from a sheet onto another sheet based off of:

1.) Value in a cell in column A on sheet 1

2.) Searching for that value in column A in sheet 2

3.) Looking in column L in sheet 2 for a specific phrase, e.g. "Direct"

4.) Adding up any values in column N in sheet 2 that align with those two steps but also looking at the dates in column M so that they would be before a date in sheet 1 in cell R1

I have tried:

=SUMIFS('Weekly Summary'!A:A,A8,'Article List'!N:N,'Article List'!L:L,"DC Pick",'Article List'!M:M,'Weekly Summary'!R1)

This is giving me an error. I need this for about 300 different lines in column A on sheet Weekly Summary to look at over 7000 lines on Article List.

Essentially I want to know how much of a type of product has shipped prior to a date, searching by assortment (column A), then shipping method (column L), and before a given date where the dates are in column M and for me to be able to put a specific date into a cell on the summary sheet.

Getting this right would save me a huge amount of work in the future.