PPRuNe Forums - View Single Post - Log book on a spread sheet

8th Sep 2014, 20:59

#5 (permalink)

Old Speckled Aircrew

Join Date: Jan 2006

Location: Gloucestershire, England

Posts: 40

Likes: 1

Received 0 Likes on 0 Posts

To make K & J columns cumulative just add the previous value to your if statement.

Leave line 2 blank and in K3:
=IF(D3="P1",J3,0)+K2

and in L3
=IF(D3="P2",J3,0)+L2

Then fill down

Reply