Combining 3 sets of data into one with SumIF formula

[jdankber]

I have a list of Work Orders A with amounts, a list of Work Orders B with amounts, and a list of Work Orders C with amounts. 

Based on the list of Work Orders A, how do I bring the amounts from B and C into one output by using SumIF formula?

Please see the "Expected Output" tab from the attached "Work Orders" excel file.

[bpatel]

@jdankber ,

you could do a series of appends using the find & replace.

hope this is what you are looking for!

[jdankber · Accepted solution]

Great! It works.  Thank you!