I have a table with 5 columns and about 30 rows. A containes litres, B
kilometres, C average consumption in 100 km, D additive litres and E should
have additives average consumption in 100 km. Problem is that additive is
refueled in various periods and in between there might be 3-9 empty cells. I
have also considered to add 1 column first on left which has dates, if this
has any impact to formula-case.

How do I make formula that finds next upper value and calculates total km
between refilling additive? I have tried IF(ISBLANK(OFFSET... and
IF(ISVALUE(FIND... IF(ISERROR(... but so far nothing works.