The Summer Cup has officially kicked off! Get ready to learn, connect, and compete! Complete Community engagement tasks to earn points and unlock exclusive Summer Cup badges for your profile. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Combining 3 sets of data into one with SumIF formula

jdankber
5 - Atom

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.

 

2 REPLIES 2
bpatel
Alteryx Alumni (Retired)

@jdankber ,

 

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

 

bpatel_0-1595547348146.png

hope this is what you are looking for!

jdankber
5 - Atom

Great! It works.  Thank you!

Labels
Top Solution Authors