Sumproduct - Indirect - NOT WORKING????? Please help

[Teddy-B]

=SUMPRODUCT(--($E$7:$E$499=$A7),--($K$7:$K$499=$B$6))
I cannot get the Indirect function to work with the formula above. I have
tried:
=SUMPRODUCT(--Indirect("E7:E499"=Indirect("A7"))),--Indirect("K7:K499"=Indirect("B6"))).
My Indirect formula always returns #REF when i try to modify the last part
of the formula. What am I doing wrong?

Thanks for your help.

 

[PCLIVE]

What exactly are you indirecting? Give us an example of your data.

 

[T. Valko]

Can't tell what you're trying to do but the correct syntax would be:

=SUMPRODUCT(--(INDIRECT("E7:E499")=INDIRECT("A7")),--(INDIRECT("K7:K499")=INDIRECT("B6")))

 

[Teddy-B]

Thanks for your help, it works fine!
~Teddy-B

Can't tell what you're trying to do but the correct syntax would be:

=SUMPRODUCT(--(INDIRECT("E7:E499")=INDIRECT("A7")),--(INDIRECT("K7:K499")=INDIRECT("B6")))

 

[T. Valko]

You're welcome. Thanks for the feedback!