Thursday, May 21, 2015

yogi_Compute Cumulative Time From LOGBOOKS!G For A/C Model In LOGBOOK!C For Time Periods In Column A

                                           Google Spreadsheet   Post  #1962
              Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI    May 21, 2015
question  by Matt Volf:!mydiscussions/docs/Gdkry18ZwbA
Need help with a formula for my pilots logbook in sheets.
I need help figuring out a formula that will sum all flight time in a specified model of aircraft during a specified time period.


I want to sum all flight time in a Cessna 172 in the past 6 months.
Here is a link to the spreadsheet.

I am looking for a formula that will total all flight time (Logbook!G)  that was flown in a specific model (logbook!C) within in a specified time (past 30 days, past 6 months, whatever I specify)