Sum a columns depending on pattern

Closed
josh07429 Posts 16 Registration date Friday June 23, 2017 Status Member Last seen November 20, 2017 - Nov 20, 2017 at 06:06 PM
Hi,

I need help in adding the mileage of cars. the rule is simple.. start adding the miles from cells that contains "Movement Start" until "Movement Stopped", everything in between those two text should be added just like the example photo below.

I've been using a formula before that will add the same cells that has the same text. the problem here is I need to set the range of cells I need to add depending on the cell names. any help would be appreciated thanks in advance