ExcelBanter - Formula error

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Formula error (https://www.excelbanter.com/excel-discussion-misc-queries/192063-formula-error.html)

This formula works:

=SUMPRODUCT(--(Data!$L$7:$L$9998='Monthly
Summary'!A18),--(Data!$AE$7:$AE$9998='Monthly Summary'!$C$1))

I wanted to add one more condition and wrote the below based on that:

=SUMPRODUCT(--(Data!$L$7:$L$9998='Monthly
Summary'!A35),--(Data!AE7:AE9998='Monthly
Summary'!$C$1),--(Data!K7:K9999='Monthly Summary'!A13))

The working formula is great. Where did my sintax go wrong or what is
happening to give me a value error?

The last array isn't the same size:

Data!$L$7:$L$9998
Data!AE7:AE9998
Data!K7:K9999

--
Biff
Microsoft Excel MVP

"Jeremy" <jeremiah.a.reynolds @ gmail.com wrote in message
...
This formula works:

=SUMPRODUCT(--(Data!$L$7:$L$9998='Monthly
Summary'!A18),--(Data!$AE$7:$AE$9998='Monthly Summary'!$C$1))

I wanted to add one more condition and wrote the below based on that:

=SUMPRODUCT(--(Data!$L$7:$L$9998='Monthly
Summary'!A35),--(Data!AE7:AE9998='Monthly
Summary'!$C$1),--(Data!K7:K9999='Monthly Summary'!A13))

The working formula is great. Where did my sintax go wrong or what is
happening to give me a value error?