Excel Formula

[MSharm83]

Hi Experts,

Need help in understanding how I can write this in Alteryx.

SUMPRODUCT(([Item '#]=A2)*(P2<[Lot1]))+1)

Where Item # and Lot1 are the columns A and P respectively. 

[danilang]

Hi @MSharm83 

Can you provide an excel sheet as some sample data?

Thanks

Dan

[Qiu]

@MSharm83 
I assume your formula should like precisely

=SUMPRODUCT((A3:A7=A2)*(B2<B3:B7),A3:A7,B3:B7)

Then we can do it in alteryx like this.