Running Total/Sum depending on adjacent row value

[kashif.alvi]

My table contains data of multiple vehicles ordered by vehicle registration number and then their date-wise statuses (such as ignition on, ignition off, driving etc.) I have an odometer column which tells me the distance covered between the last status and the current status. I need to insert a running total beside this column. Its quite easy doing it for a single vehicle, however, when the next vehicle is traversed, the total keeps on running, whereas, it should start again from zero!

 

[ashish514]

Your question is not clear to me. Can you explain??

 

[kashif.alvi]

Here I've posted an example below:

VehicleID Status Odo RunningODO
abc driving 1 1
abc driving 1 2
abc driving 2 4
abc driving 1 5
xyz driving 0 0
xyx driving 1 1
xyx driving 3 4
xyx driving 2 6
xyx driving 0 6
pqr driving 3 3
pqr driving 3 6

Which function do i put in the last column to calculate RunningODO

 

[mmmarks]

for above table you can use this function.
=IF(A2=A1,C2+D1,C2)
but I'm sure there is another acurate way.

 

[Aladin Akyurek]

Here I've posted an example below:

VehicleID Status Odo RunningODO
abc driving 1 1
abc driving 1 2
abc driving 2 4
abc driving 1 5
xyz driving 0 0
xyx driving 1 1
xyx driving 3 4
xyx driving 2 6
xyx driving 0 6
pqr driving 3 3
pqr driving 3 6

Which function do i put in the last column to calculate RunningODO

Also...

C2, copied down:

=SUMIF($A$2:A2,$A2,$B$2:B2)

 

[T. Valko]

Here I've posted an example below:

VehicleID Status Odo RunningODO
abc driving 1 1
abc driving 1 2
abc driving 2 4
abc driving 1 5
xyz driving 0 0
xyx driving 1 1
xyx driving 3 4
xyx driving 2 6
xyx driving 0 6
pqr driving 3 3
pqr driving 3 6

Which function do i put in the last column to calculate RunningODO

Is this what you had in mind...

Book1
	A	B	C	D
1	VehicleID	Status	Odo	RunningODO
2	abc	driving	1	1
3	abc	driving	1	2
4	abc	driving	2	4
5	abc	driving	1	5
6	xyz	driving	0	0
7	xyx	driving	1	1
8	xyx	driving	3	4
9	xyx	driving	2	6
10	xyx	driving	0	6
11	pqr	driving	3	3
12	pqr	driving	3	6
Sheet1

This formula entered in D2 and copied down:

=SUMIF(A$2:A2,A2,C$2:C2)

 

[kashif.alvi]

Thanks Valko, you're a lifesaver. Didn't know it was going to be so simple!

 

[T. Valko]

Thanks Valko, you're a lifesaver. Didn't know it was going to be so simple!

You're welcome. Thanks for the feedback!