Sum a columns depending on pattern

[Closed]
Report
Posts
16
Registration date
Friday June 23, 2017
Status
Member
Last seen
November 20, 2017
-
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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!