How to loop over and do math for all rows?

I am making a game tool. I have an arbitrary number of area shields. My goal is to add up the damage of an arbitrary number of area shields. The damage lookup table is named areadata. The lvl of area shield chosen in drop down can be used to lookup the damage in the areadata table.

I have not quite figured out the easiest way to make the multiplication then arrive at a total sum. Thank you.

Thank you.

Try the schedule workflow on a list function. :+1:t2:

You might want to take a look at List Shifter: List Shifter: Reverse, Rotate, Swap and ITERATE (Loop) Over Bubble Lists | Now at v1.4: Adds Numeric Option, GET INDEX Action

1 Like

Though there is also a sumproduct function that might also be what the OP is looking for. (Consult reference.)

This topic was automatically closed after 70 days. New replies are no longer allowed.