Looking up a Value in a column and then subtracting from another looked up column with different values

Jeff Dimitroff 1 Reputation point
2020-09-09T19:43:35.2+00:00

Hello,

I am trying to subtract the Main Hole from the Main Hole and then divide by the interval cost. It has to be for each well name the same.

23544-image.png

So for Crew F9-05 Main Hole 2 should be $167601.75/(5180-2257)

Is there a formula for this.

Regards,

Jeff

Universal Windows Platform (UWP)
{count} votes