Excel 2007 : Using sumif with variable multipliers

I'm afraid there is an obvious and simple answer to my problem but I'm just not thinking of it. Here goes:

I need a formula that provides the results of a sumif formula but has each component of the total multiplied by a factor that could vary for each item. Perhaps it could also be described as a sumproduct applied only to specific records. For example, in the two tables below I want to find (sumif?) the total of "C" as a taker in the top table times the tax rate of the givers shown in the bottom table. The answer expected for "C" is 90 (50+45). I need a solution that does not require adding a seperate column to calculate the tax for each row because the actual application of the formula will be in a large complex model that doesn't allow the necessary extra columns. I can't seem to nest a vlookup or other formula within sumif but I'm not convinced this is the answer anyway. Please help with suggestions.

giver taker value
A C 100
B C 60
B D 75

Player tax%
A 50%
B 75%
C 33%
D 20%

Thanks DaddyLL. This does the trick on my simple example. It seems the solution was where I was looking for it but I still can't get my head around the steps in this formula. Any chance you can explain the logic? My next step is to apply this formula to the list @E2:E5 and net the giver/taker values such that A=(50) & B=(101.25) and the net for all = 0. Further, I will actually need to calculate the tax rate in column F from two other columns, say Prior year taxes / Prior year revenue. I think I can handle this if I can just grasp the logic in this sumproduct(sumif) solution you provided.

Thanks for the input Dgagnon. This solution is where I was when I hit a wall. The problem is that it counts at the takers rate, rather than the different givers rates. I am actually using this formula for part of the model. It just doesn't give the right answer when there are different tax rates.

Here is a slightly expanded sample based on the solution DLL provided

Fantastic! I was just about to write back explaining I was hitting the same issue with sumif not allowing internal formulas when your post came through. Not only does it seem to work perfectly, it is cleaner logic than I was going to use. I still need to get my head around the full logic as I use it for several areas of the model, but it looks like there is enough her for me to get the hang of it.

To answer your question givers can be takers they just can't give to themselves...although I don't think it should matter. The real application of this is for exchange of items that have varied units of measure. One business unit may haul 3 tons per load and another hauls 4 tons per load. If I give a load from the first unit to the second it should only be for the 3 tons that existed in the haul to begin with. I thought I would find several other examples of this need in a web search but I didn't. Perhaps I just didn't understand the sumif array results. In any event I am truly appreciative of your time. I will check back tomorrow to close this as resolved once I check in the model.

Thanks again.