=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.

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

--

"Teddy-B" wrote in message
...
=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.

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")))

--
Biff
Microsoft Excel MVP


"Teddy-B" wrote in message
...
=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.

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

"T. Valko" wrote:

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")))

--
Biff
Microsoft Excel MVP


"Teddy-B" wrote in message
...
=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.

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Teddy-B" wrote in message
...
Thanks for your help, it works fine!
~Teddy-B

"T. Valko" wrote:

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")))

--
Biff
Microsoft Excel MVP


"Teddy-B" wrote in message
...
=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.