Log book on a spread sheet
Hi all,
I hope someone can save me from trawling through millions of google results that nearly get me the answer...........
I want to create a spread sheet as a log book but am having what I hope is a simple problem:
In my D column I will write either P1 or P2.
Column J will have the flight duration which is a working formula result of G and H.
Column K will have total time P1
Column L will have total time P2
I want the data in columns K and L to be the result of a simple sum formula that is dependent on what I put in column D (P1 or P2).
That is: if I type "P1" in column D I want the resultant sum of column J to be added cumalatively to column K whereas if I type "P2" then I want the result in column L.
Anyone?