Formula error

J

Jeremy

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?
 
T

T. Valko

The last array isn't the same size:

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula Questions 2
More SUMPRODUCT help 4
Formula results in error - don't know why 5
Complicated Count if and sumif help **Big Question!!! 1
If Statement Error 12
Arrayformulas with either/or nested to sumproduct if eitherconditions are true 13
VLOOKUP/MATCH Query - quite complex....but interesting. 3
Count of leader on multiple sheets 1

Top