PPRuNe Forums - View Single Post - Microsoft Excel and E-Logbook
View Single Post
Old 3rd Nov 2007, 12:36
  #4 (permalink)  
Temet_Nosce
 
Join Date: Jan 2007
Location: UK
Posts: 38
Likes: 0
Received 0 Likes on 0 Posts
Keep things really simple!

Setup another sheet with every day of the year on the left column and use the VLOOKUP function to extract totals for that day from your logbook. Then running totals are as simple as =sum(B1:B31). Drag this formula down and it becomes =sum(B2:B32) etc.

TN
Temet_Nosce is offline