Hi Richard,

Apologies. Basically the 'fill-up situation' will probably be different every time. In a real life example, my car needs fuel today, in my example spreadsheet there is £22.84 in the current petrol field, therefore I can put a total of £22.84 in petrol into my car. Say I do that, I then want the Current Petrol field to reset to zero. Then start totting up again from the next entry (into row 14 and so on).

Does that make more sense? It may be that there is no formula that will do this, I realise that it may be quite complex.

Thanks