Excel 2007 : Using date lookback to sum another column?

Hi,

Haven't posted in a long long time! I am requesting some help, to what I feel will be close to the finishing touches on my pilot logbook excel.

I'm hoping to somehow to a date look back, from today(), looking back 30, 60, 90, 120, 180, and 365 days. Now, I have all the dates of respective flights in Column A. In Column F I have the total hours for the respective date. I'd somehow like it to basically look at today's date, compare to Column A, figure up to a date X amount of days prior, and add up that many cells from Column F.

Is this even remotely possible? It is helpful as we pilots have to have look backs on all those days when doing job apps and such, and this would simplify a TON for me!

Any help would be greatly appreciated! I already owe the current state of my logbook to you wonderful people!

Thanks in advance!

Seeing as you are using Excel 2007, take a look at using the SUMIFS function, it will allow summing of cells based on multiple criteria. You may want to use a couple of cells as the date input cells and reference the input cells rather than hard-code the dates.