Return a Value sum based upon a Cell Value

[mattfromcanada]

Possibly a bit of a complicated situation.

I'm doing up a price breakdown for carpentry work, and who I'm going to assign it to.
Column A contains the price for the work, Column B contains the Trade that will be completing the work.
Can I have a cell that will sum up all of the column A Values that are assigned to each trade on Column B?
ie, A1,2,3,7,8,10 are assigned to 'Trade 1'
A4,5 are assigned to 'Trade 2'
A6,9 are assigned to 'Trade 3'
C1 will show the value of all work assigned to 'Trade 1'
C2 will show the value of all work assigned to 'Trade 2'
C3 will show the value of all work assigned to 'Trade 3'

I'd like this to be able to live update in case I need to transfer work from one trade to another. Ideally, I'd actually prefer the 'C' column on a separate sheet but that may not quite work. This is for construction purposes and it's always changing.

I've tried this on my own, and I'm getting nowhere!

Thanks

[Pepe Le Mokko]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[mattfromcanada]

Here's my working template. I've forced the values and tried to explain it with a few notes.

Much appreciated

Carpentry Breakdown Template.xlsx

[sktneer]

Try this......
In C3

=SUMIF('CARPENTRY BREAKDOWN'!$I$4:$I$36,$A3,'CARPENTRY BREAKDOWN'!$F$4:$F$36)

and copy down.

Is this what you are trying to achieve?

[mattfromcanada]

Sktneer, I don't think that's what I'm looking for. Though I may be copying it incorrectly. Are you basing this upon my original post, or the template I put up?

[sktneer]

See the attached sheet and shift the job to another person and see if the changes are reflected in the yellow formula cells.

[mattfromcanada]

That worked great. Thanks so much. I had to change some of the column names as I've added some, bu this helps me greatly.

Regards,

[sktneer]

You're welcome. Glad I could help.
If that takes care of your question, please mark your thread as Solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.
Moreover you may also click on * (star) to Add Reputation if the solution provided helped you. This is another way to say thanks.