For the Excel geeks out there I have an interesting (modified) SUMPRODUCT formula that will SUM anything you like within a table. You can filter any date range you wish, or, for any particular aircraft type, or, the summation of Instrument Flying for any date range you might wish to enter. Anything and everything you want; it depends upon how you want to set it up!
For one of the calculations the formula looks like this; which calculates the total flight time for a start date and end date for a given pilot name and aircraft type. Your table might contain several thousand entries, nonetheless, it works a treat!
=SUMPRODUCT(--('FLIGHT LOG'!$A$2:$A$34>=$A$2),--('FLIGHT LOG'!$A$2:$A$34<=$B$2),--('FLIGHT LOG'!$B$2:$B$34=$D$7),--('FLIGHT LOG'!$E$2:$E$34=C8),'FLIGHT LOG'!$H$2:$H$34)
I have a tutorial file for anyone who wants it... drop me a PM.
Ciao
TCF