Excel formula Automation

[kunalkhanna1132]

I would like your step by step input on how to automate this excel formula of a column using Alteryx.

'=SUMIFS('Fact'!AE:AE,'Fact'!E:E,1,'Fact'!AE:AE,NUMBERVALUE(AG2))

Where Fac is another excel sheet in the same workbook, AE and E are columns in Fac and AG2 is another column in the worksheet in which the formula is written.

Thanks.

[aatalai]

try the summarise tool group by AG and sum all teh values, you might also use some filters before hand. @kunalkhanna1132 let me know how you get on