I am trying to develop a logbook. There will be about 20 columns and unlimited rows. On a separate summary page I would like to break some of the numbers down.
Let's say in Flight Time. How can I get Excel to look backwards from today's date 90, 180 days, 6 months, etc, and calculate the total for the specified time.
I also need this figure to be transfered from the main worksheet to the Summary worksheet. How do I do all of this?
Can you also tell me how to make Excel total the columns for an infinite number of rows?
Thank you so much!
Let's say in Flight Time. How can I get Excel to look backwards from today's date 90, 180 days, 6 months, etc, and calculate the total for the specified time.
I also need this figure to be transfered from the main worksheet to the Summary worksheet. How do I do all of this?
Can you also tell me how to make Excel total the columns for an infinite number of rows?
Thank you so much!