SUMIFS in Alteryx Using Formula Tool?

[BobbySweaters]

Hi All, 

Is there a way to run SUMIFS (multiple conditions) in the Formula tool that creates another column in the original input file and displays the results of the SUMIFS in every row?

Alternatively, if I use the Summarize Tool I know I can get the SUMIFS by grouping, but then I want to add those SUMIFS back into the original file so that every row from the input file has the results of the SUMIFS.

Please the attachment for what I need the output to look like.

Any help would be appreciated! 

[Kottapally_Ramesh · Accepted solution]

Hi,

Please find the attached solution for SUMIFS.

[BobbySweaters]

Thank you!