SOLVED
Combining 3 sets of data into one with SumIF formula
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
jdankber
5 - Atom
‎07-23-2020
03:46 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Solved! Go to Solution.
Labels:
- Labels:
- Join
2 REPLIES 2
bpatel
Alteryx Alumni (Retired)
‎07-23-2020
04:36 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
you could do a series of appends using the find & replace.
hope this is what you are looking for!
‎07-24-2020
09:26 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Great! It works. Thank you!
