PPRuNe Forums - View Single Post - Microsoft Excel and E-Logbook
View Single Post
Old 3rd November 2007 | 12:36
  #4 (permalink)  
Temet_Nosce
 
Joined: Jan 2007
Posts: 38
Likes: 0
From: UK
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  
Reply