How can I change the criteria in an array to replace sumproduct?

Hi there!

My Excel skills have reached their limit. I have a large, bloated file that's only going to get bigger, so I'm streamlining it - or trying to.

This is the second sheet I'm streamlining - I've attached a file with sheet 1 ("DATA!") and sheet 2 (YEARLY SUMMARIES!".

DATA! has a few header rows and the from row five onwards I write in the data for my flights.
YEARLY SUMMARIES! is where I have the sheet make a summary of my annual flight hours.

On the DATA! sheet, I've used five array formulae and these seemed to have worked great.

On the YEARLY SUMMARIES! sheet, I'm working on columns E, H, K and N - they're all a variation on the same formula. Can I replace the SUMPRODUCT formula with an array? I can't alter the format as this mimics my paper logbook and the entire idea of the sheet is to automate the addition. I've manipulated the formula so it references the date in Column D, shown in MMMM format (i.e. January, February, etc....).

Is there anything I can do to reduce the number of formulae used? Arrays? The problem I have is getting the criterion in arrays to change with each line, and also I have the six month subtotal breaking up the months, which probably stops me using arrays as effectively.

Hope someone likes a challenge and can help!

Excel Forum.xlsx

Thanks DonkeyOte - much appreciated. If I'm looking at expanding the rows of data to, let's say, 10,000 rows; would arrays help reduce file size and calculations then in the main data sheet?

Thanks for the tidied up formulae. I appreciate the summary page isn't too intensive. I have about 4000 rows of data at present and would like to have the sheet handle the next two to three years of flights.

Thanks again! Really appreciated!
DC