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

G

Guest

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

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

Guest

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

T. Valko said:
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")))
Click to expand...
 

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

Sumproduct Help 2
Combine SUMPRODUCT with INDIRECT function 2
Help Plz 8
What wrong is it on using the indirect function? 2
stop excel automatically changing formulas 3
Using INDIRECT Function and INDEX Function 1
Problem using ADDRESS() in SUMPRODUCT() 2
Formula Question 1

Top