Sumif with anchored reference - Can Alteryx do this?

[craigedelman]

Trying to replicate a function that I have in excel.  It looks through a list of materials in a certain priority order, then assign existing stock on hand to how far down the list we can fulfill orders.  If decrements the existing inventory on each row based on the quantity of supply on hand.  Essentially telling me how far down a list of materials I can ship and when I run out of inventory.

It's fairly straightforward in Excel with a sumifs formula with an anchored reference.  Is this possible in Alteryx?

Example spreadsheet attached.  Trying to replicate functionality in columns E,F,G.

Thanks in advance!

[binuacs · Accepted solution]

@craigedelman One way of doing this 

[craigedelman]

This worked perfectly!  Thank you for such a quick and easy solution.  Alteryx gets better with each thing I learn.