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