Not Sure on Function

[Neil M]

I don't know whether I need a vlookup or if or what, but I will try to explain.

I have a sheet for use in construction to track backcharges between
subcontractors. For example, if one sub damages something and I have to pay
another sub to fix it, then I have to backcharge the cost of the repair to
the sub who damaged it.

So I have columns as follows that are pertinent to tracking $ amounts and/or
producing desired results:

D3 - Total $ Amount of PCO (Potential Change Order)
E3 - Responsible Sub (Sub who damaged item)
F3 - PCO Sub 1 (name from defined list "sub1")
G3 - $ amount PCO sub 1 charges to fix
H3 - PCO Sub 2 (name from defined list "sub1")
I3 - $ amount PCO sub 2 charges to fix
J3 - PCO Sub 3 (name from defined list "sub1")
K3 - S amount PCO sub 3 charge to fix

(NOTE: the reason there may be more than 1 sub fixing something is that it
may involve more than 1 trade and I need different people to fix)
L3 - The amount (if any) I am responsible for
M3 - Backcharge (Yes or No drop down option)
N3 - Actual backcharge amount to responsible sub
O3 - Change Ordered needed (yes or no drop down option)
P3 - Actual Change Order Amount

Now at the bottom of the sheet I would like to have totals of who is getting
backcharged what in $ amounts.
I have all the subs listed as they are in my defined list "sub1"
As I enter $ amounts in the columns G3, I3 and K3 I would like all those
totals for the entire sheet to add in one cell by their name at the bottom.

Let's say cell A25 is "Joes" (from the list) I want cell B25 to add all the
totals from above every time I have to charge Joes for something.

I hope this makes sense.

Thanks,
Neil

 

[Pete_UK]

I think you can use SUMIF for this, along the lines of:

=SUMIF(E$3:E$24,A25,P$3$24)

giving the net charge to the sub whose name is in A25. Copy the
formula down if you have other names below A25.

Hope this helps.

Pete