If statement with Sumifs in Alteryx?

[moinshaik]

I need to create a workflow which can replicate nested IF function with Sumifs function used in excel. I am new to Alteryx and juggling between different tools but unable to produce desired output.

I have attached input file which has dataset along with the output (Column I is the output required in alteryx) I am expecting to produce. Column A to H is an Input.

[Dazzerman · Accepted solution]

Hi moinshaik,

Here is a solution to your problem.

You could further tweak it by converting any resulting nulls to zeros in the final stage, but at least the basic steps are here for you. 

I hope this helps!

[moinshaik]

Thank you so much for the solution. It worked.