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(--($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

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