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