Recreating this sumif formula

[HafeezA]

How do i recreate this in alteryx.

=SUMIFS(Imp!$AE:$AE,Imp!$I:$I,C1)+SUMIFS(Imp!$AE:$AE,Imp!$I:$I,N1)

Summing two criteria in the same range 

[apathetichell]

Don't know this specific formula but i'd expect it has to do with summarize grouping. There might be a self-join in there too.

[messi007]

@HafeezA,

Could you share a sample data with what you expect to have? It will help us to give you the solution.

Regards,

[Sebastiaandb]

@HafeezA 

Not sure if this is what you're searching for :-)! If i strictly follow your formula of summing 2 sumif's formula's you'll end up adding rows 2 times (might be your goal, not sure). Anyway, got multiple solutions for you in the attached workflow :-), hope it helps!