SUMPRODUCT Help Please

[Joe Gieder]

First thank you for your help.
I know this is a simple problem but I cannot get it to work it returns
#VALUE!. I have this formula:
=SUMPRODUCT(--($R$2:$R$7051=R2),($L$2:$P$7051))
and what it should do is look for all like vendor names R2:R7051 and if
there's a dollar value in L27051 I just want to sum the dollar amounts and
put the answer in S2:S7051. What am I missing?

Thank you for helping
Joe

 

[Joe Gieder]

Thank you for the explanation. It helps me to understand and learn more.

Joe

 

[Max]

=SUMPRODUCT(--($R$2:$R$7051=R2),($L$2:$P$7051))

Try it as:
=SUMPRODUCT(($R$2:$R$7051=R2)*OFFSET($L$2:$P2,,,7050))

 

[Joe Gieder]

It worked great thank you.. what does L22,,,7050 do?

 

[Max]

Welcome, Joe.
Thanks for feedback.