Help in transforming an excel formula into Alteryx workflow

Question

Hey guys!

I would like your help in automating this excel formula G2=SUMIFS('Lity'!E:E,'Lity'!AE:AE,1,'Lity'!E:E,AJ2) in Alteryx.

This is the formula for a column in which as rows change AJ row number increases in formula too.

I would like if someone could help me give detailed steps on how to automate this particular formula. Lity is another sheet.

stevemarkovick · Answer

I’ve faced the same challenge when moving logic from Excel to Alteryx. The key is breaking the formula into smaller steps using Alteryx tools—like Formula, Multi-Row, or Summarize—rather than trying to replicate it in one go. Sometimes a simple IF in Excel becomes a conditional expression in Alteryx. Once I stopped thinking “cell by cell” and more in terms of workflows, it clicked.

kunalkhanna1132 · Answer

Hey @Qiu I don't have a sample input or output. I'm just checking if my train of thought is correct for automating this formula in Alteryx.

Qiu · Answer

@kunalkhanna1132 
Do you have any sample input and outout you can share?