One user in a forum of Excel Help asked solution for the following: "I have an Excel worksheet in which I log my flight hours. There are two primary columns: Column A is the date of my flight and column B is the number of hours flown for that particular flight. There can be multiple flights per day, so multiple rows per day. I am continually adding rows to the flight log. I need a way to calculate the number of hours flown over the last X days, where X could be 183 (6 months) or 365 (12 months). Any guidance would be much appreciated. —Forrest Voss " Answer: Using SUMIFS function the above can be solved. Please see the attached file.
0 Comments
Leave a Reply. |
|