If a VBA macro solution interests you...
Here's one that will calculate the 30 day total when the flight hours is entered in column F.
Assumptions are that the 12 monthly sheets are the only sheets in the workbook, the sheets are in order, and the cell in column A immediately after the last day of the month is blank. Some of yours were blank and some had spaces in them.
|