help with formula

Occasional Visitor

Hi there, really struggling to work out this formula.Screenshot 2022-02-07 221933.png

What I am trying to do is put a formula into cell U2.  The formula must check each cell in the row going backwards from T2 to I2 until it finds a value, the first value it finds must then be deducted from F2. The result of the calculation would show in U2.


Any help would be much appreciated.

1 Reply


In U2:


Fill down.