I need to make table to see my hours flown per year and month wise

[Jitendra162]

Hi,
I am a Pilot and just made an excel logbook for myself.
I am not able to get a formula to create a table which will show me the hours I have flown in a year and month wise
My date is in column A and the hours I want in the table is in column J.

And as a pilot I need to keep a track of my 3 take off and 3 landing in last 90 days to keep me current. I managed to create that to show take off and landing in last 90 days which it shows the number of take off and landing I did in past 90 days. I want find out the date of my 3rd last take off and landing from which I can add 90 days to show me the expiry date.

would really appreciate if you can help me to solve this.

attaching a sample sheet.

Thank you.
Jitendra Nor

[PaulM100]

Formula in table: =SUMPRODUCT(--(YEAR(Logbook!$A$4:$A$2459)=$C3),--(MONTH(Logbook!$A$4:$A$2459)=MONTH(D$2)),Logbook!$J$4:$J$2459)

Formula for last take off: =LOOKUP(2,1/(Logbook!$Z:$Z<>""),Logbook!$A:$A)

for this to work, I changed your headers from text to actual months(1/1/2020) and user a custom format of "MMM"

[Jitendra162]

thanks a lot for the formula it works exactly how I wanted.
and for the take off the formula is showing me the date of my last take off whereas I wanted the date of my 3rd last take off which is on 28-06-2020.

[PaulM100]

Try this: =INDEX(Logbook!$A:$A,LARGE(IF(Logbook!$Z:$Z<>"",ROW(Logbook!$Z:$Z)),3))
Array entered using Ctrl+Shift+Enter instead of regular Enter

[Jitendra162]

It worked perfectly, Thank you very much.

Cheers.