SUMPRODUCT Help Please
 

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 L2:P7051 I just want to sum the dollar amounts and
put the answer in S2:S7051. What am I missing?

Thank you for helping
Joe

SUMPRODUCT Help Please
 

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

Joe

"Max" wrote:

whoops ... think the OFFSET wasn't necessary here

This simpler version seems to work just as well:
=SUMPRODUCT(($R$2:$R$7051=R2)*($L$2:$P$7051))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

SUMPRODUCT Help Please
 

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

Try it as:
=SUMPRODUCT(($R$2:$R$7051=R2)*OFFSET($L$2:$P2,,,70 50))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Joe Gieder" wrote:
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 L2:P7051 I just want to sum the dollar amounts and
put the answer in S2:S7051. What am I missing?

Thank you for helping
Joe

SUMPRODUCT Help Please
 

It worked great thank you.. what does L2:p2,,,7050 do?

"Max" wrote:

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

Try it as:
=SUMPRODUCT(($R$2:$R$7051=R2)*OFFSET($L$2:$P2,,,70 50))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Joe Gieder" wrote:
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 L2:P7051 I just want to sum the dollar amounts and
put the answer in S2:S7051. What am I missing?

Thank you for helping
Joe

SUMPRODUCT Help Please
 

Welcome, Joe.
Thanks for feedback.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Joe Gieder" wrote:
Thank you for the explanation. It helps me to understand and learn more.