How to use If statement with Sumifs in Alteryx?

[akanksha01]

Hi,

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 I am expecting to produce.

Please suggest.

Thanks

[alex · Accepted solution]

This should help

[akanksha01]

Thanks Alex.

I tried your way and applied CountNullNonDistint instead since I wanted three different results (No, Yes and No Data), and along with this used "IF c THEN t ELSEIF c2 THEN t2 ELSE f ENDIF" in Multi Field Formula for Null, 0 and 1 key, and that worked perfectly.

Thanks again.