Sumproduct - Indirect - NOT WORKING????? Please 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.
|