SUMPRODUCT #VALUE error

I am trying to sum the numbers in L10:AC310 if column a is a date after the reference date in A312 and column F is 41000. I get a #VALUE error with the below formula and can't figure out why.

=-SUMPRODUCT(--($A$10:$A$310>$A$312),--($F$10:$F$310="41000"),($L$10:AC$310))

When I break the formula down into its parts (as below), none of the parts return errors.

=-SUMPRODUCT(--($A$10:$A$310>$A$312))
=-SUMPRODUCT(--($F$10:$F$310="41000"))
=-SUMPRODUCT(($L$10:AC$310))

The only information I could find on SUMPRODUCT #VALUE errors was mismatched ranges or text/blanks and as I understand it, the --, format should eliminate the blanks problem. There are lots of blank cells in the array to sum.

Any help would be greatly appreciated.

The shape (#rows; #columns) of all parameters must be the same. L10:AC310 is 2-dimensional, whereas A10:A310 and F10:F310 are 1-dimensional.

Instead, write:

=-SUMPRODUCT(($A$10:$A$310>$A$312)*($F$10:$F$310="41000")*$L$10:AC$310)