I am keeping a pilot log, and would like to be able to easily add up various combinations of totals (ex. cross-country at night, cross-country as pilot-in-command, multi-engine instrument). Each type of flying is logged separately in columns by date in rows. I've attached a simplified version to work with.
What I think I need is a way to find the lower(est) entry of 2 or more columns (ex. B1 and D1), for multiple rows (i.e. all rows in the sheet), and sum all the lower(est) entries to come up with a grand total. It would need to be able to treat blanks as zero.
I've attached a sample excel file and image. In the sample sheet, I've manually added to find results for "Cross-country and Night" and for Instrument and "Pilot-in-Command." In a perfect world, I'd love to be able to choose various criteria from dropdowns like in L2, M2, N2 and it retrieve a total as described above.
Bookmarks