sum values of adjecent cells in a row if cells in a seperate column contain a value

[endep]

Greetings,

First time here. I have a fairly good feel for excel but haven't been able to put this together, let's see if I can explain.

I have in column A and B, dollar amounts for specific purchases. In column C there are numbers representing vendors. What i would like to do is set up a formula to look at column C and find all cells containing, for example, 5 (code for vendor). Then look to the adjacent cells in column A and B for the dollar amounts purchased from vendor 5 and sum a total dollars spent. So just to explain from a slightly different angle; there could be 10 or 15 logged purchases from vendor 5 in column C in no particular pattern or order. I want it to find all the rows in column c with a value equal to 5 then look left into the A and B column and give a combined total of all the dollar amounts.

Any guidance is greatly appreciated.

[Bob Phillips]

Try

=SUMPRODUCT((C:C=5)*(A:B))

[endep]

thank you!

[NBVC]

Try:

=SUMIF(C:C,5,A:A)+SUMIF(C:C,5,B:B)

you can replace the 5's with a cell reference if you are copying formula down for other Vendor codes.